Viewing 15 posts - 1 through 15 (of 45 total)
Try using the query below to get query plan, that might help you with figuring out which procedure is being executed .
May 29, 2018 at 9:03 am
Try this , tweak the script to suit your needs.
--declare variable, type: tableDECLARE @MyTable TABLE (Input NVARCHAR(30))
--insert sample valuesINSERT INTO @MyTable...
October 30, 2017 at 5:00 am
Why Would you want to do that instead of using SQL functions to do your SUM ?
You can very easily generate SQL to do the updates:[code...
August 25, 2017 at 4:57 am
August 14, 2017 at 8:29 am
Sue_H is right , maintenance plans don't delete file if they have ".' on the extension. Also check if the SQL Agent account has access to delete in the directory
August 14, 2017 at 8:27 am
August 14, 2017 at 8:21 am
Hope you resolved this.
Experienced the same thing all i did was install Latest 2016 SP1
July 12, 2017 at 8:08 am
Use Execute SQL Task instead of OLE DB SOURCE , make sure you have a variable for every column so that you can map your Exec SQL task result set...
July 7, 2017 at 9:43 am
One file per file group provided you going to put the on separate disks , even the index filegroup should be on the different disk
July 7, 2017 at 6:37 am
You can achieve this using a linked server with the query below, just tweak it to use the linked server .
NB: The account used for the linked server...
May 16, 2017 at 8:34 am
May 16, 2017 at 8:20 am
On the destination server after migration. OPEN the database master key using the same password as on the source server.
NB : The OPEN command works for the same session...
February 24, 2016 at 1:35 am
Great Question .
February 24, 2016 at 1:08 am
" Any ideas on where to look to determine why this occurred? "
Jo Pattyn already answered the first place to look at is Windows Eventviewer.
February 18, 2016 at 5:24 am
Very good script .
January 25, 2016 at 12:20 am