April « 2011 « SQL Server Journey with SQL Authority

Archive for April, 2011

SQLAuthority News – Last 5 Days to WIN Windows Phone 7 – 140 Words to Win

Posted in Pinal Dave, PostADay, Readers Contribution, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on April 20, 2011 | 4 Comments »

You can win Windows 7 Phone by writing only 140 Characters. You need to leave a comment over here: SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL over here. There are so far around 150 comments and I believe that chances of one person to win the [...]

Read Full Post »

SQLAuthority News – Sudden Death of SSD on my Laptop – A Warning for SSD Users

Posted in About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on April 19, 2011 | 25 Comments »

The solid state drive on my personal laptop just died. Here’s the story. I have a DELL XPS laptop which is now 2.5 years old. The laptop had demonstrated no issues. About 6 months ago, I decided to upgrade the hard drive to solid state drive. There was a lot of hype in the market [...]

Read Full Post »

SQL SERVER – Speaking on T-SQL Worst Practices at Great Indian Developer Summit 2011 – Bangalore

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 18, 2011 | 10 Comments »

Presenting in front of techies is always fun. I will be speaking at Great Indian Developer Summit 2011 – Bangalore on April 19, 2011. Here is the details of my session: Session Title:“What did I do?” – T-SQL Worst Practices “Oh My God! What did I do?” Chances are you have heard, or even uttered, [...]

Read Full Post »

SQL SERVER – Applying NOLOCK Hint at Query Level – NOLOCK for whole Transaction

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on April 17, 2011 | 14 Comments »

Just received very interesting question in email: “How do I apply NOLOCK hint to my whole query. I know that I can use NOLOCK at every table level but I have many tables in my query and I want to apply the same to all the tables. I want to do something like following script. [...]

Read Full Post »

SQL SERVER – Making Database to Read Only – Changing Database to Read/Write

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on April 16, 2011 | 4 Comments »

I recently received following comments on my earlier blog: “Today i was trying to attach the (MDF,NDF,LDF ) sql server 2008 database which i have received from my client. After attachment the database status is showing (Read-Only) (Eg.database name (Read-Only). How do i make to normal mode for the data updation. is there any query [...]

Read Full Post »

« Newer Posts - Older Posts »