Viewing 15 posts - 40,186 through 40,200 (of 49,552 total)
Tony Davis (3/23/2009)
Part of what I was wondering with this editorial was: what are the equivalent "classics" for the DBA?
For a classic, I'll vote for Ken Henderson's Guru's guide...
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
March 23, 2009 at 2:12 pm
Steve, it looks like all three of the recent posts options (since last visit, today and this week) are maxing out at 150 entries. Currently all three are showing me...
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
March 23, 2009 at 2:09 pm
Lynn Pettis (3/23/2009)
Steve, your presentation was well done, and you should start seeing me blogging soon.
Woot! :w00t:
Mail me the URL when you get it launched?
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
March 23, 2009 at 10:23 am
If you have 5 SQL instances on one machine (virtual or not), you need to limit their memory. SQL is a memory hog and will take as much as it...
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
March 23, 2009 at 9:27 am
vwilliams (3/23/2009)
I am having the same problem. I cannot change the compatibility level on the database because of older applications.
Also posted here - http://www.sqlservercentral.com/Forums/Topic681532-145-1.aspx
No replies to this...
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
March 23, 2009 at 9:25 am
If they have permission to query a view, then they'll be able to see the definition of it.
If they have any permissions at all on the object, then they...
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
March 23, 2009 at 9:07 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/Topic681491-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
March 23, 2009 at 9:03 am
There are Performance tuning forums for both SQL 2000 and SQL 2005, likewise T-SQL. There's a forum for SSIS. Pick the forum that matches the version that you're using and...
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
March 23, 2009 at 9:03 am
Just one point on the datareader. You said that it can view objects, but not stored procedures. That's not technically true.
The way the system objects are set up, a user...
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
March 23, 2009 at 8:48 am
Oscar Fernandez (3/23/2009)
SQLServer has information for index that are not used.
That info's only since the last start of the SQL service. The data in the index usage DMV is 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
March 23, 2009 at 8:10 am
Please post in an appropriate forum in the future. The Website upgrade forum is for discussions and problems with the SQL Server Central web site.
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
March 23, 2009 at 8:00 am
Kop_Eoin (3/23/2009)
My formatting may not be the best but X means that they have this ability.
Yes, I realise that. Your grid has Create/alter login listed twice, sysadmin is checked on...
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
March 23, 2009 at 7:29 am
neil (3/23/2009)
Thanks VERY MUCH Gail for responding, it would be great to have Paul chime in on this too.
He's at SQLConnections at the moment so probably rather busy, but I...
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
March 23, 2009 at 7:13 am
Your grid indicates that sysadmin cannot create or alter logins. That is incorrect.
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
March 23, 2009 at 6:56 am
If you don't have an existing SQL trace, there's no way to tell who did this. The SQL log should have an entry saying that it happened, but not who...
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
March 23, 2009 at 6:52 am
Viewing 15 posts - 40,186 through 40,200 (of 49,552 total)