Recently I tried to install SQL Server 2012 in Windows Server 2012 box. Unfortunately it was not easy to do that for me because setup generated few errors. And then I it displayed that .NET Framework 3.5 SP1 Feature was not able to activate. There were few reasons to occur that problem. Windows Server 2012 was not activated. Windows Server ...
I have seen in many video tutorials they have different tabs for Editor, Results, Messages and Execution Plans. And they are streched over complete screen. Most of the times need to resize the result area to see our results. Actually its annoying me. Then I noticed in on of Paul Randal’s video he uses Separate tabs for Results editor and ...
Before two weeks I saw a post about lightning talks of SQLServerUniverse. So I applied for a lighting talk about “PowerPivot in SQL Server”. Then the A/L exam came to me. So I had no time to create a presentation for that. Hence the day before the physics exam I searched on the internet for “PowerPivot Slides”. Then I found ...
I wanted to learn about data types. Then I went to technet some how most of the important things were there in technet documentations. But I found another way to get figures from SQL Server. We can have details of data types from “sphelp”. You just have to give your data type as a parameter like below. EXEC sp_help int ...
In SQLCMD and Powershell I wanted to take the list of databases. In MySQL “show databases” command was there. But in SQLCMD I was unable to find such a command. --Stored Procedure EXEC sp_databasesGO --SELECT Statement SELECT Name FROM master.dbo.sysdatabasesGO You can use above commands in SSMS (if you are lazy to move your mouse to object explorer) and SQLCMD. ...
Before few weeks I got a book from Oreilly Blogger Review program to review a book. I took enough time to read this book. This book covers most of the new trends and features in SQL Server 2012 with good explanation. I was addicted to first chapter to get to know about the SQL Server Data Tools. Because previously I ...
I’m still a beginner in SQL Server. Then I will blog about so many basic things in SQL Server. Inserting is very important Data Manipulation Statement. So lets see how to use INSERT Statement in different ways. USE tempdb GO --Creating Table CREATE TABLE tmpTable ( [id] int NOT NULL, [name] varchar(100) NULL, [address] varchar(1000) NULL ) GO --Inserting Data ...
