Viewing 15 posts - 38,986 through 39,000 (of 49,552 total)
Constraints if possible, triggers only when the constraint can't be implemented. What you have there sounds like a standard unique constraint. If it's not, post more details.
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
May 21, 2009 at 12:12 am
Lynn Pettis (5/20/2009)
Bob Hovious (5/20/2009)
Gail: There's hope!Many people have cats but go on to live perfectly normal lives. 😛
As long as you remember this one...
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
May 21, 2009 at 12:04 am
Nope. If that doesn't work, it won't restore.
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
May 21, 2009 at 12:02 am
Lynn Pettis (5/20/2009)
Insanity is hereditary, you get it from your kids-- reference unknown
Edit: And for those without kids, I have no explanation.
Do cats count?
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
May 20, 2009 at 3:27 pm
Alex Prusakov (5/20/2009)
- A.STATUS='A' or A.STATUS IS NULL clause makes impossible to use any index by SQL Server;
SQL can use an index to satisfy that, depending (of course) on 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
May 20, 2009 at 3:11 pm
Grant Fritchey (5/20/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
May 20, 2009 at 10:35 am
josephptran2002 (5/20/2009)
Where can I find the SSIS or import/export wizard?
They're both part of SQL server.
can you send me a link of how to use it?
http://www.google.com/search?q=SSIS
http://www.google.com/search?q=%22Import+Export+Wizard%22+%22SQL+Server%22
Or perhaps you could...
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
May 20, 2009 at 9:44 am
Lynn Pettis (5/20/2009)
You know what? I think some of us (me included) really need a vacation in some far off exotic locale. Too bad I can't afford one...
Yup....
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
May 20, 2009 at 9:38 am
You cannot update an identity column. If you absolutely need to change some values, delete the row and then reinsert it specifying the identity value (with identity insert on)
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
May 20, 2009 at 9:34 am
naveenreddy.84 (5/20/2009)
Will using NOLOCK in the Stored procedure for SELECT State would provide performance beneficit?
Nolock is not a performance tool. It controls the accuracy of the data read by 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
May 20, 2009 at 9:33 am
I would suggest you contact customer support. It's not supposed to break.
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
May 20, 2009 at 9:33 am
Gianluca Sartori (5/20/2009)
Can you help us with some ideas on the short circuit side?
Maybe.
I've seen SQL short circuit some expressions, emphasis on some. Mostly in cases of expressions based on...
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
May 20, 2009 at 9:28 am
Why all this hassle with OPENROWSET? What's wrong with SSIS or the import/export wizard? This is exactly what those tools are there for. Why don't you try using one of...
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
May 20, 2009 at 9:18 am
Gaby Abed (5/20/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
May 20, 2009 at 8:36 am
ip2host (5/20/2009)
ok what do you think i should do:
1) Read the article that I linked about managing transaction logs
2) Tell your boss that he's risking the business by having no...
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
May 20, 2009 at 8:29 am
Viewing 15 posts - 38,986 through 39,000 (of 49,552 total)