Viewing 15 posts - 33,841 through 33,855 (of 49,552 total)
Elliott W (2/23/2010)
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
I have 2. One has 'geek' written in L33t.
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
February 23, 2010 at 11:50 pm
Messages from the SQL error log please.
Exact errors you got when querying the DB please.
I'm not able (or willing) to help without both. I don't want paraphrased descriptions. Exact messages.
As...
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
February 23, 2010 at 11:50 pm
Jack Corbett (2/23/2010)
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
February 23, 2010 at 1:13 pm
Check in Books online what the minimum permissions are for each of the things he'll need (ask him for a list) and then evaluate how you're going to do 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
February 23, 2010 at 1:11 pm
If you check in books Online, it lists the permissions needed to query each DMV in the page on that DMV
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
February 23, 2010 at 11:54 am
moosamca (2/23/2010)
I am having a few questions here. Could you please describe why we need to include these columns on the index.
Because the columns are in the select clause...
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
February 23, 2010 at 10:52 am
Hunterwood (2/23/2010)
Have you ever seen a performance problem using the code bellow (copied from the article)?
IF ( SELECT COUNT(*) FROM .... WHERE ...) > 0BEGIN
...etc
END
Not on SQL 2005/2008. It 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
February 23, 2010 at 10:36 am
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
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
February 23, 2010 at 10:07 am
I would strongly suggest, if you don't have the skills in-house to fix this, call MS's customer support people. They will charge you, but it's better than depending on people...
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
February 23, 2010 at 10:03 am
Please don't cross post. It just wastes people's time and in general multiple posts in multiple forums is more likely to irritate people than cause them to help you.
No replies...
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
February 23, 2010 at 10:00 am
Please don't cross post. It just wastes people's time and in general multiple posts in multiple forums is more likely to irritate people than cause them to help you.
No replies...
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
February 23, 2010 at 10:00 am
Are we geeks or 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
February 23, 2010 at 9:52 am
Currently sitting with colleague who I don't see often discussing disk performance issues over supper.
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
February 23, 2010 at 9:51 am
Please post all messages in the error log and exactly what you've done until this point. Also the output of SELECT @@Version
I suggest you don't make any more attempts to...
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
February 23, 2010 at 9:48 am
Lynn Pettis (2/23/2010)
Should we save the 12,000 post for Gail when she gets back from being on-site with a client?
You'd have to wait until Thursday afternoon if you want to...
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
February 23, 2010 at 9:47 am
Viewing 15 posts - 33,841 through 33,855 (of 49,552 total)