What’s new in SQL Server RC0 setup

Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read More MS SQL Server 2012 RC0 includes new edition – SQL Server Business Intelligence,  Read More Service Pack 1 is the minimum requirement for Windows 7 and Windows Server 2008 R2 operating systems, Read more Data Quality Services can be installed using SQL Server 2012 RC0 Setup, Read more Product update is the new feature available with MS SQL Server 2012 RC0, this will integrate latest update...

Read More

Revamping Surat User Group

Dear Friends, we had a user group meeting last week – I and Vinay Pugalia was  here. We have discussed many things to revamp and re-launch Surat User Group. Here are the minutes of meeting: 1) Regular Meetings -> Monthly, Proposed schedule :Saturday evening, 1900 to 2000 2) Regular Events -> 1 every 2 months, 1 workshop every quarter 3) Decide and form SUG Website, with Blog,Forums section, Facebook page and twitter handle 4) Press Notes after every event 5) Help from CSI Surat -> Have to meet, discuss and encourage...

Read More

Maintenance Plan mystery

Last week I had interesting (or I can say weird ? ) case of Maintenance Plan. One of the server that we monitor has reported job failure – this was a part of maintenance plan. Looking at the job history and log file I came to know that this job was failing because of some database which wasn’t available – this database was dropped few days back, and, the maintenance plan has it’s reference stored somewhere. I have search around system tables etc. but nothing unusual or nothing helpful was available that indicates the source of this database....

Read More

Using NOLOCK hint

Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local user group events and meeting. I have always advised that its not that good idea to use hints, as it may cause data corruption and blocking. And, anyways, there are many things that you can do to avoid blocking, like: use sp for everything (almost)   try to avoid using cursor transaction shouldn't be too big etc and, use READPAST hint , I will still say, use this only when you don't have choice But these all comes from...

Read More