Viewing 15 posts - 4,951 through 4,965 (of 11,678 total)
I chose the third answer: same results but randomized, because if you'd include a column from sys.all_columns, you'd see the first result set is random.
Ah well, nice question anyway. 🙂
September 3, 2013 at 2:26 am
ChrisM@Work (9/3/2013)
Jan Van der Eecken (9/3/2013)
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams...
September 3, 2013 at 1:17 am
Steve Jones - SSC Editor (9/2/2013)
dwain.c (9/2/2013)
dwain.c (9/1/2013)
Brandie Tarvin (8/30/2013)
Which means I have just spent all morning recovering all my SSMS options, importing...
September 2, 2013 at 11:24 am
And that's why it is so sad MS abandoned the MCM program...
September 2, 2013 at 3:33 am
This is the source of the error:
Cannot open backup device 'J:\MSSQL10_50.SLQnombert\MSSQL\Backup\Full_Backup\Nombertprod ombertprod_backup_2013_09_02_094915_1589136.bak
Does the file exists? Does the user Nombert\SQLCCL01 have access to it?
September 2, 2013 at 3:07 am
Try deploying with dtutil.
Do you have Integration Services installed?
September 1, 2013 at 2:27 pm
Which version of SSIS?
September 1, 2013 at 2:09 pm
To develop SSIS packages and SSRS reports, you need SQL Server Data Tools (SSDT), which is a Visual Studio 2010 shell.
You can install this using the SQL Server set-up.
September 1, 2013 at 2:08 pm
I spent 15 minutes thinking if it was a trick question or not.
Glad it wasn't 😀
Happy Labor Day! (where apparently, you don't do any labor.)
September 1, 2013 at 2:07 pm
GilaMonster (8/31/2013)
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a...
September 1, 2013 at 1:35 pm
A clustered index on the date makes sense.
You can always add nonclustered indexes if needed to support the reports.
September 1, 2013 at 1:31 pm
harsimranjeetsinghwasson (8/30/2013)
Do i need to schedule the same as i tried to add my procedure created in master database but logging the time in table of other user defined...
August 30, 2013 at 3:50 am
Viewing 15 posts - 4,951 through 4,965 (of 11,678 total)