Viewing 15 posts - 38,386 through 38,400 (of 49,552 total)
If you want the underscores to be treated as literals rather than wildcards, you need to escape them.
SELECT class_code FROM tbl_class WHERE class_code LIKE 'ep/_f/_%' ESCAPE '/'
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
June 17, 2009 at 1:26 am
Interesting.
I'm doing M.Sc at the moment and my study fees are R7000 per year. That's Masters by dissertation, so no course work involved.
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
June 17, 2009 at 1:12 am
Jeff Moden (6/16/2009)
Now, if we could just get them to say that UPDATEs always work in clustered index order... 😛
They won't. The unofficial word from one of the guys 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
June 17, 2009 at 1:11 am
Just a couple things with that.
It's likely to perform badly. Take a look at the blog post I referenced earlier. Also, before you use nolock, read this: http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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
June 17, 2009 at 1:08 am
Jeffrey Williams (6/16/2009)
GilaMonster (6/13/2009)
And the quote button from time to time.
Interesting you say that cause I have seen it a couple of times now. I think I have 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
June 17, 2009 at 1:07 am
Please post the exact messages from the SQL error log.
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
June 16, 2009 at 1:50 pm
GilaMonster (6/16/2009)
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking 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
June 16, 2009 at 1:45 pm
Oh dear, this one's not going to be pretty....
http://www.sqlservercentral.com/Forums/Topic735954-357-1.aspx
Suspect DB, and a very new 'DBA'
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
June 16, 2009 at 1:38 pm
In management studio open Object Explorer. Management - SQL Server Logs.
If there's a senior DBA there get him involved. Suspect database are serious issues. If not, consider calling MS's customer...
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
June 16, 2009 at 1:33 pm
Is the D drive still accessible?
Is the .mdf file where SQL expects it to be? (D:\programfiels\michrosoft sql server\mssql\data\tiger_data.mdf)
Does the SQL Server service account have full rights (read and write) 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
June 16, 2009 at 1:18 pm
How to recover depends completely on what's actually wrong. Check the SQL error log, there should be error messages indiating why the database is suspect. Check those messages, post them...
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
June 16, 2009 at 1:14 pm
If you've got all the files from the DVD there should be two folders. 'Servers' and 'Tools'. Inside the Servers folder there should be a 'setup.exe'. Run that.
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
June 16, 2009 at 1:10 pm
Roy Ernest (6/16/2009)
Gail, I think it will be Sri Lanka that is going to take it. SA has no clue how to play spinners.. 🙂
Ooohhh... You're asking for 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
June 16, 2009 at 1:04 pm
Jeff Moden (6/6/2009)
Paul White (6/6/2009)
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
June 16, 2009 at 12:58 pm
rodjkidd (6/16/2009)
Roy Ernest (6/16/2009)
Roy, have you been keeping up with it? Or is 20-20 not your thing?
I have been keeping up with it. Seems like Sri Lanka and South Africa...
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
June 16, 2009 at 12:49 pm
Viewing 15 posts - 38,386 through 38,400 (of 49,552 total)