Viewing 15 posts - 136 through 150 (of 644 total)
JimS-Indy (10/17/2012)
Note Capture 5 -- SQL Server Configuration Manager.Capture 6 -- Server Manager.
The configuration manager screenshot clearly shows that you do not have 2 instances installed on your system, there...
October 17, 2012 at 8:11 am
JimS-Indy (10/16/2012)
I upgraded my SS2k5 instance to SS2k8 using the standard upgrade process from MS, but the instance still shows as ss2k5. I don't understand.
Could you please provide the...
October 17, 2012 at 4:24 am
deepa lekshmi (10/16/2012)
We require to convert a list of SPs to SSIS packages. Most of the SPs do the below steps:
1. create a table and insert data into that...
October 17, 2012 at 4:06 am
Nice question. Don't see a trick in it as long as NULL is within quotes. However, explanation is absolutely incorrect:cool:
October 17, 2012 at 2:53 am
SQLSACT (10/5/2012)
I'm struggling to understand the READ_COMMITTED_SNAPSHOT isolation level.
If I have a database with the READ_COMMITTED_SNAPSHOT isolation level turned on and I execute a query that starts with set...
October 5, 2012 at 7:15 am
Heh...Seems "correct" answer is "incorrect". If the question is about how many rows are returned, the answer is 2,0. Period.:cool:
October 5, 2012 at 1:59 am
I am not sure why the question is being criticized. For me, it was a straight forward question. The question asks which query will insert the data in the table...
September 27, 2012 at 8:12 am
Thanks for the nice, easy question :-). I say it easy because I have seen it many times, on SQLSkills.com. Paul Randal has used this (INSERT INTO TableName DEFAULT VALUES)...
September 27, 2012 at 3:03 am
ananda.murugesan (9/26/2012)
When checkpoint is returned for log_reuse_wait_desc it means the No checkpoint has occurred since the last log truncation, or the head of the...
September 26, 2012 at 7:18 am
Viewing 15 posts - 136 through 150 (of 644 total)