Viewing 15 posts - 3,316 through 3,330 (of 49,571 total)
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...
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
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,...
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.
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,...
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,...
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'.
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...
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...
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.
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...
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...
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...
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!"
April 5, 2016 at 8:10 am
Viewing 15 posts - 3,316 through 3,330 (of 49,571 total)