Thank you for an excellent article, my knowledge of SB is hazy and it's nice to see a practical application of this feature. The only disappointment (NOT from you!)...

Check this link: http://msdn.microsoft.com/en-us/library/ms174393.aspx for info about QUOTED_IDENTIFIER - I've not tried what you're describing before but I think that by setting it ON you can avoid the quotes problem....

"minimal typing skills"? So you want your applicant not to be able to use a keyboard, then?

My last contract was very restrictive in terms of IPR. Basically if I spent any time on personal projects in work, or using work equipment in any way, the...

Go to Google and type site:qa.sqlservercentral.com + "your handle" + "keywords" to find a specific post. Google's indexing is pretty good.

3935 (6/28/2012)

In Derived column i am trying to create Double quotes? for 1 column . And i use code like this ("\""+ Day+"\"") but i am getting and...

I started with the course book from Microsoft for 70-432 but can't say I was overly impressed with it. Tom Carpenter's book 'SQL Server 2008 Administration: Real-World Skills for...

Normally the backup application log refers to the calling application that started the BACKUP command. For example, if you're using SSIS Maintenance Plans and SQL Server Agent Jobs, check...

Caught me out there, I returned 3 of the 4 correct answers. 2,NULL,0 I thought is not valid. Well done.

I did a

SELECT * FROM sys.dm_os_ring_buffers AS dorb;

i am getting 3660 rows and this is 1 row

0x0000000000406240 RING_BUFFER_EXCEPTION 6815052 <Record id = "7426" type ="RING_BUFFER_EXCEPTION" time ="6815052"><Exception><Task address="0x00000000047DA988"></Task><Error>200</Error><Severity>25</Severity><State>16</State><UserDefined>0</UserDefined></Exception><Stack><frame...

Hi

There's a thread about this topic here -> http://qa.sqlservercentral.com/Forums/Topic1305679-61-1.aspx

If you're on a volume license agreement or a software assurance program, you'll need to buy the 2012 licensing option which is per-core not per-processor.

This can be expensive so alternatively...

You're welcome. FYI upgrading the RAM could be pointless if you're on a 32-bit architecture.

Reason being, 2^32 = 4GB.

Best thing to do is manage the memory you have and...

Indexes are your friend here. Also think about archiving old data from the table (stuff that hasn't been read/updated for some time, easily found if you have a datetime...

Look at what the triggers are doing. If they are executing SPs or ad-hoc SQL code using commands for which you haven't given permissions, the triggers will fail.

Please post...