Viewing 15 posts - 316 through 330 (of 880 total)
Good question, something new learned, thanks Steve.
January 31, 2018 at 12:11 am
Or even
SELECT TABLE_SCHEMA,
January 30, 2018 at 3:59 am
January 30, 2018 at 12:37 am
Good question thanks Steve, learned something new.
January 29, 2018 at 10:30 pm
Why would you migrate only some tables? If you are sharding the DB to give a separate server to certain clients or geographical locations then SSIS is your tool, to...
January 29, 2018 at 8:27 am
January 29, 2018 at 3:50 am
January 29, 2018 at 2:52 am
Working from the excellent suggestion by Sean, but tweaking slightly, try this:
DECLARE @jsondate...
January 29, 2018 at 2:40 am
January 28, 2018 at 10:31 am
Better still rewrite the whole thing as an SQL Agent job (or jobs) and get rid of those Maintenance plans!!
January 28, 2018 at 10:30 am
I seem to recall this script was plagiarised recently, which seems to have been sorted, but I recall a very pertinent question on that thread about 'what if the schema...
January 28, 2018 at 10:24 am
In my experience this is caused by an incorrect time server setting. The consequences of resetting the time are SQL jobs may be missed or repeated. Auditing may become invalid....
January 26, 2018 at 8:47 am
Viewing 15 posts - 316 through 330 (of 880 total)