Viewing 15 posts - 10,096 through 10,110 (of 22,213 total)
I don't have an answer for you, but I contacted someone at Confio to see if they can help you out.
January 31, 2013 at 5:54 am
Do you mean validate the data structure of a SQL Server database?
Or do you mean validate the layout of a SQL Server installation?
Or do you mean evaluate SQL Server as...
January 31, 2013 at 5:46 am
Or, look to a third party tool like Red SQL Data Compare & SQL Compare. But you can't use the backup process to only move pieces of a database. Backup...
January 31, 2013 at 5:45 am
None that I'm aware of. The level of flexibility there is pretty limited. To do it right, you really have to make all the objects functional, otherwise the builds fail...
January 31, 2013 at 5:42 am
Hearty 'well dones' to both Chad and Brandie.
January 31, 2013 at 5:30 am
BrainDonor (1/30/2013)
jasona.work (1/30/2013)
Now, you want a topic that would *really* generate some responses, start a Star Trek vs Star Wars topic,Babylon 5 or nothing.
+Infinity!
January 31, 2013 at 5:28 am
f_ernestog (1/29/2013)
I added parameter sniffing to the SP
Totally confused. Parameter sniffing is on by default for all stored procedures and parameterized queries. It requires a traceflag to turn it...
January 29, 2013 at 11:36 am
You are two service packs behind.
January 29, 2013 at 11:34 am
DominantDBA (1/29/2013)
The 2 hour restore is if we lose both it has to be available within 2...
January 29, 2013 at 8:23 am
Brett Phipps (1/29/2013)
January 29, 2013 at 6:38 am
Try posting to the 2000 forum. You'll get answers more suited to SQL Server 2000 than posting in the 2008 forum.
To identify the longest running queries back in 2000, I...
January 29, 2013 at 6:30 am
Jeff Moden has a great article[/url] on how to use a tally table to break up a comma delimited list.
January 29, 2013 at 5:42 am
GilaMonster (1/29/2013)
sqlnaive (1/29/2013)
there is no way we can updates the statistics in middle of the whole process.Why not?
+1
January 29, 2013 at 5:40 am
OK. That's probably a good reason for it, but, know that you are potentially looking at radically slower performance. Partitioning requires pretty disciplined code to work well. From the sounds...
January 29, 2013 at 4:54 am
Brandie Tarvin (1/29/2013)
Steve Jones - SSC Editor (1/28/2013)
Perfect example of a question that should be here, not on ASK
What is ASK for?
I'm still not 100% sure. But, the concept is...
January 29, 2013 at 4:51 am
Viewing 15 posts - 10,096 through 10,110 (of 22,213 total)