Viewing 15 posts - 40,801 through 40,815 (of 49,571 total)
James Goodwin (2/24/2009)
February 24, 2009 at 9:27 am
Bob Hovious (2/24/2009)
The tests I ran suggest (to me anyway) that it really isn't enough extra work to worry about.
It's not just about work. It's about doing things...
February 24, 2009 at 9:10 am
Derek Dongray (2/24/2009)
Maybe the posted questions have stopped getting worse and OPs are starting to ask sensible questions with well-formatted sample data?
More likely, everyone was so busy chatting about favourite...
February 24, 2009 at 8:13 am
Derek Dongray (2/24/2009)
February 24, 2009 at 8:08 am
And if the column been compared to is char or varchar, preceding the constant with N can kill performance as it prevents index seeks. (Inplicit conversion on the column)
February 24, 2009 at 8:00 am
kim.talley (2/24/2009)
Anyone have any opinions or suggestions for how to handle 'emergency' updates to production by the developer staff?
Yeah. Don't.
All updates, even emergency ones, should be done by the DBAs....
February 24, 2009 at 7:44 am
raveen4u (2/24/2009)
I have database of pgsql on linux ... But I'm new to linux.
This is a Microsoft SQL Server site. You'll get far better responses if you find a forum...
February 24, 2009 at 4:30 am
If you created a trigger you will see it under the triggers folder for each table in Object Explorer. Did you refresh object explorer after creating the trigger?
February 24, 2009 at 2:32 am
amit (2/23/2009)
MCDBA training...
Most of the MCDBA exams are retired or will retire next month. MCDBA is the old SQL 2000 cert.
Look a the link Steve gave for...
February 24, 2009 at 1:44 am
jakemike1 (2/23/2009)
Thanks for all the info guys, and as I'm rather new to SQL I have taken your suggestion Ten Centuries and created a script using the GUI.
There's no one...
February 24, 2009 at 1:34 am
What does SELECT @@version return?
What querying tool are you using?
February 24, 2009 at 1:15 am
nivedita.kathal (2/23/2009)
yes that was 1204....because we have SQL server is 2000.
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely...
February 24, 2009 at 1:14 am
Max (2/23/2009)
Have to finish renovations and moving first though and this reading until 2am is probably not a good idea 😀
It's better than working til 2am.
February 23, 2009 at 5:50 pm
Max (2/23/2009)
Here are a couple from kalahari.net
Thanks
I don't usually buy from Kalahari. Their prices are often worse than a physical books shop, especially when shipping's factored in
I'll drop by...
February 23, 2009 at 5:24 pm
Bob Hovious (2/23/2009)
It may hit 2000 posts before midnight.
In who's timezone? It's past that in mine.
February 23, 2009 at 3:28 pm
Viewing 15 posts - 40,801 through 40,815 (of 49,571 total)