Viewing 15 posts - 9,826 through 9,840 (of 39,883 total)
arr.nagaraj (5/4/2015)
one of the needs for auditing to be async is, in most of the shops, the infrastructure...
May 5, 2015 at 8:43 am
I'm with Gail, somewhat on this. It's not that I think it's harder for me to restore or recover, but it is slightly less readable and confusing. That's the concern...
May 5, 2015 at 8:42 am
David.Poole (5/3/2015)
May 4, 2015 at 10:14 am
RonKyle (5/4/2015)
If you have EE, I tend to agree that moving stuff out of the Primary file group makes some sense. However, for most of the databases and instances, I'm...
May 4, 2015 at 10:12 am
Xavon (5/4/2015)
Interesting question.But I am disappointed the QotD was not May the 4th related.
sorry, too busy and didn't think of it. Anyone want to send me one for next year...
May 4, 2015 at 9:25 am
Take it, Shawn.
I think showing it a few ways would be good as it's likely a short one.
May 4, 2015 at 9:24 am
RonKyle (5/4/2015)
Why or how does this matter?
It makes the database a little more robust because isolating the system tables from the data tables and indexes reduces the chance that the...
May 4, 2015 at 9:24 am
jonathan.crawford (5/1/2015)
Jeff Moden (5/1/2015)
May 2, 2015 at 4:38 pm
Your question or post doesn't really have context or make sense.
May 2, 2015 at 12:34 pm
Eric M Russell (5/1/2015)
Steve Jones - SSC Editor (5/1/2015)
david.gugg (5/1/2015)
May 1, 2015 at 9:54 am
Looks like security issues. Note that the SQL Agent has to have rights here. The Network Service account doesn't necessarily have rights to get to the files you're working with.
Can...
May 1, 2015 at 9:52 am
The error gives you the problem. You need features enabled on the remote machine.
SQL Server is an application that runs inside Windows. As such, it doesn't have access to...
May 1, 2015 at 9:46 am
If someone is sending you a string and you want to use it as a part of a WHERE clause, you'll need to be sure you use dynamic SQL in...
May 1, 2015 at 9:42 am
1TB, but how big on average? The average size matters more for performance and issues.
If these aren't read often, I might also try to compress them.
May 1, 2015 at 9:32 am
Viewing 15 posts - 9,826 through 9,840 (of 39,883 total)