November « 2010 « SQL Server Journey with SQL Authority

Archive for November, 2010

SQL SERVER – Information Related to DATETIME and DATETIME2

Posted in Pinal Dave, SQL, SQL Authority, SQL DateTime, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 15, 2010 | 1 Comment »

I recently received interesting comment on the blog regarding workaround to overcome the precision issue while dealing with DATETIME and DATETIME2. I have written over this subject earlier over here. SQL SERVER – Difference Between GETDATE and SYSDATETIME SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE SQL SERVER – Difference Between DATETIME [...]

Read Full Post »

SQL SERVER – ERROR – FIX – Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because it is currently in use

Posted in SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 14, 2010 | 6 Comments »

I often go to do various seminars and presentations at various organizations. During presentations I often create and drop various databases for demonstrations purpose. Recently in one of the presentations, I tried to remove my recently created database, I got following error. Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because [...]

Read Full Post »

SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database

Posted in SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on November 13, 2010 | 18 Comments »

While engaging in a performance tuning consultation for a client, a situation occurred where they were facing a lot of CXPACKET Waits Stats. The client asked me if I could help them reduce this huge number of wait stats. I usually receive this kind of request from other client as well, but the important thing [...]

Read Full Post »

SQL SERVER – Get All the Information of Database using sys.databases

Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on November 12, 2010 | 12 Comments »

Earlier I wrote blog article SQL SERVER – Finding Last Backup Time for All Database. In the response of this article I have received very interesting script from SQL Server Expert Matteo as a comment in the blog. He has written script using sys.databases which provides plenty of the information about database. I suggest you [...]

Read Full Post »

SQLAuthority News – SQL Server Denali CTP1 – Release Date November 9, 2010

Posted in SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on November 11, 2010 | 10 Comments »

I am very excited as I was about to witness SQL Server 2011 – Code Named “Denali” is released on November 11, 2010 at SQLPASS. I will write a detail report for the same in future. You can download CTP1 right away right now and install on your machine. The major features of the new [...]

Read Full Post »

« Newer Posts - Older Posts »