Viewing 15 posts - 3,316 through 3,330 (of 49,552 total)
No. Watch the news articles, it'll be announced when it happens.
Typically anyone who knows in advance isn't allowed to say anything.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 6, 2016 at 3:15 am
Why?
In general this is a really bad thing to do. Suspended means that the session is waiting for something, and you only mention how long the session has been...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 6, 2016 at 3:12 am
The SQL Server objects are named for the instance name. They'll be something like MSSQL$InstanceOne/Memory Manager
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 3:23 pm
To start with UNION means remove duplicates, and IN doesn't care if you have duplicates, so UNION ALL rather.
Make sure you test both multiple times. If you only test once,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 1:34 pm
Eirikur Eiriksson (4/5/2016)
Further on John's replay, hardly worth zipping the compressed backups unless one is applying encryption in the process.
On SQL 2014, rather encrypt the backup natively, as it's taken.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 12:53 pm
You need to identify the slow queries and fix them. No silver bullets here, no magic solutions. Most performance problems are bad code and/or bad indexes (usually both)
This article's dated,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 12:52 pm
I'd recommend 2016. We're at RC2 at this point, gut feel we'll see RTM late this month, maybe next month.
2016's got a lot of interesting new stuff in it,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 12:49 pm
Read Your Error Messages!
The DELETE statement conflicted with the REFERENCE constraint "FK_ContractorCoverage_Postal_CountyRegion". The conflict occurred in database "PrData", table "dbo.ContractorCoverage", column 'CountyRegionID'.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 10:10 am
szejiekoh (4/5/2016)
- seems like db mirroring can achieve the closest RPO/RTO but it is obsolete soon
And 2-node availability groups in Standard edition is coming (in SQL 2016)
Thus , we are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 10:04 am
You don't need to take the diff or log backups. After the publication is created, the changes will get copied to the distributor and will be synced to the subscriber...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 10:00 am
Yup. Create the publication, then take the backup. You don't need diff or log backups for replication, just a full backup taken after the publication was created.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 9:31 am
Welsh Corgi (4/5/2016)
I'm still trying to determine which tables to Drop the constraint on.
Read your error messages.
Error: The DELETE statement conflicted with the REFERENCE constraint "FK_Postal_CityTownship". The conflict occurred in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 9:29 am
coolchaitu (4/5/2016)
Dear Gail Madam,How to know which query caused tempdb to become full 1 hour back?
GilaMonster (4/5/2016)
coolchaitu (4/4/2016)
Also, is there a way to find what caused tempdb to become...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 9:28 am
p.shabbir (4/5/2016)
And if you don't mind can you let me know about second scenario.a clustered index on COL_A, COLB, COL_C and a non clustered index on say COL_C
Those are two...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 8:15 am
ccd3000 (4/5/2016)
'Code stink'? Wrong type of language.
"Cannot run out time. There is infinite time. You are finite. Zathras is finite. This is wrong tool!"
http://www.imdb.com/title/tt0517722/quotes?item=qt0422044
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 5, 2016 at 8:10 am
Viewing 15 posts - 3,316 through 3,330 (of 49,552 total)