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 ...

I got few questions to answer quickly in last week just like a test. Then I suddenly answered then after that I tried to find correct answers to them. I found answers for most of them. And one of them was there as it was. A Windows server has 32 GB of memory and dedicated for SQL Server database. Every ...

Previously I wrote a post about CTE (Common Table Expressions). And Common Table Expressions are valid for a single statement only. But a single statement can use many CTEs. And statement also should be within the same batch. USE AdventureWorks2012 GO --Defining CTE WITH ctePerson AS( SELECT * FROM Person.Person) --First Statement will run SELECT FirstName FROM ctePerson --Second statement ...

Previously I wrote a post about CTE (Common Table Expressions). And Common Table Expressions are valid for a single statement only. But a single statement can use many CTEs. And statement also should be within the same batch. USE AdventureWorks2012 GO --Defining CTE WITH ctePerson AS( SELECT * FROM Person.Person) --First Statement will run SELECT FirstName FROM ctePerson --Second statement ...

In SQL Server we use varchar, varbinary to save disk space in our tables. But it’s not saving data always as it sounds. When the data stores it takes a few extra bytes to describe the data length. Because of that, there is no gain using varchar(2). If you use varchar(2) it will take 4 or 3 bytes to store ...

In SQL Server we use varchar, varbinary to save disk space in our tables. But it’s not saving data always as it sounds. When the data stores it takes a few extra bytes to describe the data length. Because of that, there is no gain using varchar(2). If you use varchar(2) it will take 4 or 3 bytes to store ...

Previously I wrote a post about CTE (Common Table Expressions). And Common Table Expressions are valid for a single statement only. But single statement can use many CTEs. And statement also should be within same batch. USE AdventureWorks2012 GO --Defining CTE WITH ctePerson AS ( SELECT * FROM Person.Person ) --First Statement will run SELECT FirstName FROM ctePerson --Second statement ...

In SQL Server we use varchar, varbinary to save disk space in our tables. But its not saving data always as it sounds. When the data stores it takes few extra bytes to describe the data length. Because of that there is no gain using varchar(2). If you use varchar(2) it will take 4 or 3 bytes to store data. ...

Yesterday I wrote a post with the same title. In that post I mentioned using char(1) is also the same as using a one-bit column in the table. But it is from the perspective of storage space. But using numbers is less burden to the Database engine. It means using 1 and 0 is better than using ‘Y’ and ‘N’. ...

Yesterday I wrote a post with the same title. In that post I mentioned using char(1) is also the same as using a one-bit column in the table. But it is from the perspective of storage space. But using numbers is less burden to the Database engine. It means using 1 and 0 is better than using ‘Y’ and ‘N’. ...

As I read after installing SQL Server on a System it is a best practice to disable SA account. Then I asked our architect, and one of prod DBAs. Then I got to know Yes it is a good practice if you disable SA Account because it is a well-known account. And also we can rename that account then there is no point to disable it. Somehow finally I got to know that nobody should use SA account.

As I read after installing SQL Server on a System it is a best practice to disable SA account. Then I asked our architect, and one of prod DBAs. Then I got to know Yes it is a good practice if you disable SA Account because it is a well-known account. And also we can rename that account then there is no point to disable it. Somehow finally I got to know that nobody should use SA account.

Yesterday I wrote a post with same title. In that post I mentioned using char(1) is also same like using one bit column in table. But it is from the perspective of storage space. But using numbers is less burden to Database engine. It means using 1 and 0 is better than using ‘Y’ and ‘N’. Also in comparing data ...

As I read after installing SQL Server on a System it is a best practice to disable SA account. Then I asked from our architect, and one of prod DBAs. Then I got to know Yes it is a good practice if you disable SA Account, because it is a well known account. And also we can rename that account then there is no point to disable it. Somehow finally I got to know that nobody should you SA account.

If you have Yes or No data to store in DB, what will you select as the data type? Most of the times you will select “Bit”. Because it only takes 1 bit to store data. And it is the best data type for this situation. But it takes more than a bit in SQL Server. If you have an ...

If you have Yes or No data to store in DB, what will you select as the data type? Most of the times you will select “Bit”. Because it only takes 1 bit to store data. And it is the best data type for this situation. But it takes more than a bit in SQL Server. If you have an ...

I wanted to learn about data types. Then I went to TechNet somehow most of the important things were there in TechNet documentation. 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 Then ...

I wanted to learn about data types. Then I went to TechNet somehow most of the important things were there in TechNet documentation. 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 Then ...

If you have Yes or No data to store in DB, what will you select as the data type? Most of the times you will select “Bit”. Because it only takes 1 bit to store data. And it is the best data type for this situation. But it takes more than bit in SQL Server. If you have only one ...

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 ...