Viewing 15 posts - 11,401 through 11,415 (of 49,562 total)
If you disable the clustered index, the entire table is inaccessible (can't be read or modified), so you can't do that before a load or the load will fail.
As for...
October 6, 2013 at 7:36 am
Depends on the type of DBA, the company's needs and roles and the DBA's interests.
Someone who's more a developer DBA will probably want to know .net better, someone who's more...
October 6, 2013 at 6:18 am
Depends what events you put in the trace and how you configure it. Keep traces lightweight and probably not.
October 6, 2013 at 2:42 am
madhu-686862 (10/5/2013)
We have 12 GB RAM on the node.8 GB Max Memory
1 GB Min Memory
4 GB left for OS
No other applications are installed other than SQL Server
That doesn't...
October 6, 2013 at 2:33 am
anoop.mig29 (10/5/2013)
can you plz tell me briefly what parameters i should look for memory begin uitilized by sql server
I did. The memory-related perfmon counters for SQL Server (there's 4 different...
October 6, 2013 at 2:30 am
Is there free memory for SQL to take?
October 5, 2013 at 7:51 pm
Please note: 5 year old thread
October 5, 2013 at 6:34 pm
Jeff Moden (10/5/2013)
GilaMonster (10/5/2013)
October 5, 2013 at 6:29 pm
The only time the edition matters (Enterprise, Standard, Express, etc) is when the backup contains persistent Enterprise-only features like compression or partitioning. Only when that is the case can the...
October 5, 2013 at 4:14 pm
You have any service broker configured anywhere?
October 5, 2013 at 3:50 pm
A lot of the gaming forums are starting to moderate heavily. Don't think they have much choice anymore, the amount of vile, abusive, hate type comments was just getting too...
October 5, 2013 at 3:29 pm
Lynn Pettis (10/5/2013)
GilaMonster (10/5/2013)
Lynn, re the count(*), there's about 5 different threads over the last couple months on that problem and much ignored advice.
Well, I will see what I may...
October 5, 2013 at 2:03 pm
Nothing to do with SQL Express.
You have a SQL 2008 R2 backup that you're trying to restore to a SQL 2008 instance (not R2). They're two different versions and you...
October 5, 2013 at 1:59 pm
There's nothing special about a backup made on SQL Express, a backup taken from there can be restored to any edition of SQL of that version or lower.
What's the exact...
October 5, 2013 at 11:22 am
Lynn, re the count(*), there's about 5 different threads over the last couple months on that problem and much ignored advice.
October 5, 2013 at 11:15 am
Viewing 15 posts - 11,401 through 11,415 (of 49,562 total)