Viewing 5 posts - 1 through 5 (of 5 total)
SQL Server DBA does not seem to pay well, especially for NYC area.
January 5, 2017 at 1:07 pm
Thanks for the post. But I don't understand the "DNS A" part of code.
March 9, 2016 at 7:17 am
Great post. Very clear.
What if you modify dbo.fn_SumRangeOfNumbers() to do a loop and sum without using a tally table? Would it be the same effect as dbo.StandardNameFormat()?
January 6, 2016 at 9:15 pm
I found a developer's edition in the lab. Below are the @stmt:
create database TSQL2012_Snapshot on (name=TSQL2012,filename='M:\MSSQL\DATA\TSQL2012.mdf.ss') as snapshot of TSQL2012
create database TSQL2012_Snapshot on (name=TSQL2012_2,filename='M:\MSSQL\DATA\TSQL2012_2.ndf.ss') as snapshot of TSQL2012
errors:
Msg 5127,...
December 8, 2015 at 11:15 am
Love the chart.
I don't have Enterprise Edison in our lab, can't test. Tried SP_SNAPSHOT_ALL_DATABASES on a db with 4 files, I got 4 'create' statements. Is this intended?
December 8, 2015 at 10:12 am
Viewing 5 posts - 1 through 5 (of 5 total)