Viewing 15 posts - 5,371 through 5,385 (of 22,211 total)
GilaMonster (11/17/2015)
You could buy a tool like Red Gate's SQLCompare and SQL DataCompare to sync the data and schema, but it's probably...
November 18, 2015 at 6:54 am
The up and coming technology for HA these days is Availability Groups. There are lots of good articles available at Simple-Talk.
November 18, 2015 at 6:47 am
I agree with Gail. I just didn't want to be too negative. If you have the MDF file, you can at least attempt an ATTACH. The likelihood is, everything is...
November 17, 2015 at 6:08 pm
silas.perkins (11/17/2015)
Asking for expert opinion. A very unfortunate event happened. One of our PCs crashed few days ago. That PC had SQL Server 2008 installed. Unfortunately no backup was running...
November 17, 2015 at 10:25 am
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored procedures.
They sent to...
November 17, 2015 at 8:40 am
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
I just glanced at the...
November 12, 2015 at 6:32 am
If you're on 2012, the GUI is really easy. Don't use the Wizard. It's a waste of time and more than a little misleading.
November 12, 2015 at 4:44 am
You're posting in the 2008 forum with a 2005 question.
If you were in 2008 I could tell you to look at the system_health extended event session which captures deadlock information....
November 12, 2015 at 4:41 am
No.
Differentials are like Full backups. You restore the backup using the STOPAT, then you can use logs to get to 5PM. If you use the differential, I think it'll error...
November 12, 2015 at 4:38 am
Alan.B (11/11/2015)
sgrimard (11/11/2015)
Any suggestion on good books or site to learn how to create good index?
SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) by Grant Fritchey is...
November 12, 2015 at 4:30 am
BL0B_EATER (11/12/2015)
November 12, 2015 at 4:25 am
The variable is not able to be sampled by the optimizer, so it generates an estimate from the statistics instead of using a specific value. When you pass a specific...
November 11, 2015 at 8:03 am
samot-dwarf (11/11/2015)
Just steer clear of multi-statement table valued functions, and everything will be OK.
Maybe your devs want to replace RedGateMonitor.[utils].[SplitString] with something as at http://www.sqlservercentral.com/articles/Tally+Table/72993/ :hehe:
We have a winner!
November 11, 2015 at 4:21 am
Steve Jones - SSC Editor (11/10/2015)
jasona.work (11/10/2015)
November 10, 2015 at 12:39 pm
MattieNH (11/9/2015)
Although it completely violates the spirit of the editorial, I would suggest that thismost people make great and interesting choices
should read:
most people make great or interesting choices
Ha! Also...
November 9, 2015 at 12:33 pm
Viewing 15 posts - 5,371 through 5,385 (of 22,211 total)