Viewing 15 posts - 11,401 through 11,415 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2013 at 2:30 am
Is there free memory for SQL to take?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 7:51 pm
Please note: 5 year old thread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 6:34 pm
Jeff Moden (10/5/2013)
GilaMonster (10/5/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 4:14 pm
You have any service broker configured anywhere?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 11:15 am
Viewing 15 posts - 11,401 through 11,415 (of 49,552 total)