Viewing 15 posts - 41,251 through 41,265 (of 49,552 total)
Matt Miller (2/2/2009) That doesn't mean you get to put down our little tournament:)
Oh, I'm not trying to put your 'little' tournament down. I just don't know what it'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
February 2, 2009 at 10:27 pm
Lynn Pettis (2/2/2009)
GilaMonster (2/2/2009)
Matt Miller (2/2/2009)
I'd laugh at that - but I was coding SQL while watching the superbowl yesterday....:)Super what?
Oh, right, the World Cup is the only TRUE World...
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 2, 2009 at 10:16 pm
Do you have any object named 'sysnsobjs' in your table? Do you have a user named 'sys'?
Did the upgrade adviser find any problems?
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 2, 2009 at 10:04 pm
charlesz (2/2/2009)
Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).
Really? What makes you right and Books Online wrong?
Or 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
February 2, 2009 at 9:58 pm
TheSQLGuru (2/2/2009)
2) is the join column a primary key or unique index value? Looks like cartesian product if not.
Agreed. That's one reason I want see the actual exec plan,...
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 2, 2009 at 12:50 pm
Please post the code you're using and the exact error message that you're getting.
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 2, 2009 at 12:49 pm
Matt Miller (2/2/2009)
I'd laugh at that - but I was coding SQL while watching the superbowl yesterday....:)
Super what?
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 2, 2009 at 12:44 pm
To add to what Terry posted try this article here (blatant self-promotion)
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 2, 2009 at 12:40 pm
DavidB (2/2/2009)
I'm sure all that have posted to this thread would be happy to provide some suggestions on what you have in place currently.
Oh, absolutely! The comment about prices...
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 2, 2009 at 12:31 pm
Nicholas Cain (2/2/2009)
ARCServe (and most backup solutions) have an open file agent which allows you to backup files that are in use by the OS or other programs.
That should...
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 2, 2009 at 12:30 pm
john (2/2/2009)
I need to add this records quickly and I don't have time to add the UI right now.
Use a query window and write insert statements?
What's the definition...
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 2, 2009 at 10:57 am
Nested triggers means that an update to a table in a trigger can fire triggers on that table, providing it's not the same table. So, say you have Table1 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
February 2, 2009 at 10:56 am
karthikeyan (2/2/2009)
whether choosing 'DB' as a research topic is the best option or not. is there any limitations in choosing...
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 2, 2009 at 10:50 am
What's CA?
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 2, 2009 at 10:45 am
john (2/2/2009)
To be clear I am not doing this via code. I am typing directly into the table row.
Why?
Any triggers on the table?
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 2, 2009 at 10:45 am
Viewing 15 posts - 41,251 through 41,265 (of 49,552 total)