Viewing 15 posts - 20,716 through 20,730 (of 49,552 total)
SET Manager_ID = 'Alan Curbishley' will attempt to set the managerID field to the literal string 'Alan Curbishley', and will likely fail due to data types
Start with a select, 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
January 27, 2012 at 2:52 am
Jeff Moden (1/25/2012)
Hmmm... I wonder what they did from 2k5 to 2k8 because it used to be "guaranteed" as of 2k5.
Yeah, the bugs in the metadata were fixed in 2005...
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
January 27, 2012 at 2:22 am
Lee Crain (1/26/2012)
GilaMonster (1/26/2012)
p.s. 3 year old thread.And your point is?
That Jeff (or others) shouldn't waste his time re-starting a discussion that concluded 3 years ago. Often people don't...
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
January 27, 2012 at 2:20 am
Close, but think about it logically. You want the list of managers that aren't assigned teams. to do that, you first get the list of managers that are assigned teams...
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
January 26, 2012 at 3:44 pm
Don't use join. Look up IN or EXISTS and use the NOT IN/NOT EXISTS check.
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
January 26, 2012 at 3:10 pm
For that best bet would be to use NOT IN or NOT EXISTS. Books Online (the SQL help) will have details on syntax.
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
January 26, 2012 at 2:54 pm
You would neither join nor union. Just look for rows in the teams table that don't have a value for Manager_ID
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
January 26, 2012 at 2:17 pm
GilaMonster (1/26/2012)
Anyone want to plan 'guess the syntax'? http://www.sqlservercentral.com/Forums/Topic1242094-392-1.aspxp.s. Yes, I'm been deliberately obtuse in that thread.
Or maybe 'guess the reason'? http://www.sqlservercentral.com/Forums/Topic1242314-391-1.aspx
Grant stole my crystal ball, so...
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
January 26, 2012 at 10:41 am
An increase in rows in any table could have caused the plan to change, can even be as little as 1 row in some cases.
First thing to identify - is...
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
January 26, 2012 at 10:40 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
January 26, 2012 at 10:27 am
Data volume or statisics changes could have caused a change in exec plan that resulted in more IOs. Hard to debug properly without exec plans before and after.
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
January 26, 2012 at 10:26 am
Brandie Tarvin (1/26/2012)
GilaMonster (1/26/2012)
Brandie Tarvin (1/26/2012)
Dealer: Umm, about that tiny oil leak....
I hate days like this.
I've had that. It was followed by almost R10 000 repair bill for replacing 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
January 26, 2012 at 10:25 am
Brandie Tarvin (1/26/2012)
Dealer: Umm, about that tiny oil leak....
I hate days like this.
I've had that. It was followed by almost R10 000 repair bill for replacing the gaskets in 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
January 26, 2012 at 10:10 am
Anyone want to plan 'guess the syntax'? http://www.sqlservercentral.com/Forums/Topic1242094-392-1.aspx
p.s. Yes, I'm been deliberately obtuse in that thread.
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
January 26, 2012 at 10:08 am
You know, the syntax is described in Books Online...
You've got unquoted string literals - GarrisonName, SCPCategory. They're not variables (no @ in front) and if they're supposed to be string...
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
January 26, 2012 at 10:07 am
Viewing 15 posts - 20,716 through 20,730 (of 49,552 total)