Viewing 15 posts - 36,916 through 36,930 (of 49,552 total)
The proc's execution plan will never be cached and a new one will be generated each time the proc runs. Good for procs that have no single optimal plan or...
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
August 21, 2009 at 5:06 am
Hidden and not directly queryable. None of the system tables in sql 2005 or above are directly queryable.
Why do you want to know?
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
August 21, 2009 at 5:06 am
The error's not saying that the database is in single user mode, it's saying that the server is in single user mode.
So someone has started SQL with the -m switch...
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
August 21, 2009 at 1:49 am
Auto shrink should never be on, not on a dev server even.
Auto close can be of use for databases that are very, very seldom accessed, but it's a very...
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
August 21, 2009 at 1:47 am
Local system is essentially local administrator. Full permissions on the local machine. Network service is a resticted account that has enough permissions to communicate over the network, run as a...
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
August 20, 2009 at 2:29 pm
With only 180 or so rows, you've very likely got under 8 pages in that index. Very small indexes do show fragmentation after rebuilds, it has to do with how...
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
August 20, 2009 at 2:24 pm
A quick google search shows that wmiprvse.exe is not part of SQL Server and is unrelated to SQL server. You're probably better off asking this on a general windows administration...
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
August 20, 2009 at 2:11 pm
Does the account that SQL Express is running under have write permissions to the mdf file? Is it on read-only storage?
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
August 20, 2009 at 2:05 pm
Depends what kind of parameter sniffing problems you have.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
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
August 20, 2009 at 11:06 am
To do a many-to-many relationship in SQL you need to create an intermediary table.
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
August 20, 2009 at 11:04 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic774397-145-1.aspx
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
August 20, 2009 at 11:02 am
Want to apologise to the developers? 😉
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
August 20, 2009 at 9:47 am
Get to the config shown in image 2, drag object explorer as shown in this screenshot
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
August 20, 2009 at 9:35 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic774264-5-1.aspx
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
August 20, 2009 at 9:09 am
ALTER DATABASE <Database Name> SET ONLINE
As for how it got offline, someone took it offline either by issuing a ALTER DATABASE statement or by selecting Tasks-Take offline from the context...
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
August 20, 2009 at 8:46 am
Viewing 15 posts - 36,916 through 36,930 (of 49,552 total)