Viewing 15 posts - 45,241 through 45,255 (of 49,552 total)
Miles Neale (8/7/2008)
Was that word of mouth or is there a URL that advises such?
Bit of both.
Other thing that was discovered is that you can't just go back through...
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 8, 2008 at 1:13 am
Kristin Echols (8/7/2008)
We just did our last upgrade from 2000 to 2005 this week (seriously). Maybe we can skip 2008 and wait for 2011?
Look over the new...
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 7, 2008 at 11:13 am
By 1st time, do you mean the order with the lowest order date?
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 7, 2008 at 10:55 am
Peter Schott (8/7/2008)
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 7, 2008 at 10:54 am
Adam Bean (8/7/2008)
Stupid third party vendor applications.
Lol.
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 7, 2008 at 10:31 am
Read through these three and see if they help. If you have questions afterwards, plelase ask.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/
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 7, 2008 at 10:05 am
SQL 2005's encryption allows you to encrypt specific columns in tables. It does not allow you to encrypt the entire database. (SQL 2008 has that)
Perhaps look and see if 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
August 7, 2008 at 10:01 am
It shouldn't need any extra permissions, and that is not a standard error message. It's custom and specified within the trigger (message number of > 50000)
What's the code of 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
August 7, 2008 at 9:56 am
a_lindeman (8/7/2008)
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 7, 2008 at 8:56 am
rbarryyoung (8/7/2008)
Downloaded RTM last night, can't install it until tomorrow though...
I started downloading it last night, stopped when I noticed the size. 3 GB download will use my entire month's...
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 7, 2008 at 8:28 am
The other problem is that that format of where clause tends to confuse the optimiser and has no single fixed optimal plan. You're probably getting a table scan for 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
August 7, 2008 at 7:59 am
a_lindeman (8/7/2008)
Now that SQL Server 2008 non free versions have RTMed, does anyone know when SQL Server 2008 Express Edition will be released? Thanks!
Shortly. That's all that can be...
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 7, 2008 at 7:53 am
Grant Fritchey (8/7/2008)
I got one yesterday, I think it was maybe the third one I've received over the years
I don't get many emails. I may have had four in...
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 7, 2008 at 7:44 am
MCP is an older designation and was what you got after writing and passing any one exam. MCP = Microsoft Certified Professional
MCITP is a newer designation and is the 2nd...
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 7, 2008 at 7:31 am
If you're considering exams as a verification of what you've learn more than anything, then look at the ITP (Database Developer) cert. Two exams. They are not easy
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 7, 2008 at 4:49 am
Viewing 15 posts - 45,241 through 45,255 (of 49,552 total)