Viewing 15 posts - 5,341 through 5,355 (of 9,715 total)
Another place to check is the usual assortment of certification books. They often have tutorials you can walk through yourself in how to use the various tools in SQL Server.
August 12, 2011 at 11:19 am
You're correct. The definition in BOL is pretty much identical, word for word, except for a final statement in the Insensitive part:
When ISO syntax is used, if INSENSITIVE is omitted,...
August 12, 2011 at 11:18 am
Ditto on the SSIS package. You can create it easily enough (aside from the learning curve), then schedule it with a job to run automatically.
If the other system is behind...
August 12, 2011 at 11:14 am
I'm a little confused by your post. Have you run other procs through DTA and gotten different results or do all your attempts to use DTA end up with no...
August 12, 2011 at 11:11 am
Steve Jones - SSC Editor (8/12/2011)
- work in a complex development environment that does automated builds at high volumes (> 1x day)
-...
August 12, 2011 at 10:33 am
Have you checked SP_WHO2 while this is going on to see what the SPID of the blocking process is?
Here's the code I use to see what the details of a...
August 12, 2011 at 8:16 am
That's definitely one approach. Not knowing what your environment is like, I can't say for certain that it will help you narrow down the problem, but it's a good idea...
August 12, 2011 at 8:10 am
Stefan Krzywicki (8/12/2011)
Funny, we've been going to Worldcon for years, but we skipped last year because Australia was too expensive and we're not going this year because it is in...
August 12, 2011 at 7:56 am
Deepak,
No matter what you do, there will always be an element of manual work in this process. Someone will forget to add notifications to the job they create, or the...
August 12, 2011 at 7:09 am
The difference between tech writing and fiction writing?
Fiction writers get to lie for a living, disguising it as the truth.
Tech writers have to tell the truth, making sure the truth...
August 12, 2011 at 6:48 am
SanDroid (8/12/2011)
Brandie Tarvin (8/12/2011)
SanDroid (8/11/2011)
I am only a Microsoft Certified Trainer and Red Cross Volunteer.
Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused....
August 12, 2011 at 6:46 am
Look at sysjobhistory in msdb. The message column will give you minimal details about failures (run_status = 0). The table seldom has the space to store all the details of...
August 12, 2011 at 6:44 am
It sounds like someone or something is removing the data source connection from SSRS.
Check the report to see where the data source connection is pointing to. Often times, SSRS will...
August 12, 2011 at 6:33 am
I don't advise shrinking it at all. The log space is growing because the database needs it.
If you're running out of hard drive space, add more as either a...
August 12, 2011 at 6:30 am
Hey, all. I don't know much about this subject (Other Wait statistics). Can anyone help this poster? He hasn't had any answers at all since he posted early yesterday:
http://www.sqlservercentral.com/Forums/Topic1158300-146-1.aspx
August 12, 2011 at 6:28 am
Viewing 15 posts - 5,341 through 5,355 (of 9,715 total)