Viewing 15 posts - 4,561 through 4,575 (of 18,926 total)
jcrawf02 (7/22/2011)
Ninja's_RGR'us (7/20/2011)
The Dixie Flatline (7/20/2011)
GilaMonster (7/20/2011)
Ninja's_RGR'us (7/20/2011)
GilaMonster (7/20/2011)
Jeff Moden (7/20/2011)
I understand that Gail Shaw will be co-presenting with you...
Yup, Grant and I are doing comed^H^H^H^H^H execution plans as...
July 22, 2011 at 9:37 am
More simple than 1 point and click and delete?
Nope.
Scripting will take you hours to find and learn, but I know it's possible.
Why the urgent nature of this call? Sounds...
July 22, 2011 at 9:30 am
Here's how to get all tables for all dbs. This will include rowcount. From there on out it's just a rule of 3 away...
SET STATISTICS IO, TIME...
July 22, 2011 at 9:18 am
GabyYYZ (7/22/2011)
And now for something completely different. Applies to DBA's as well.http://www.thegeekstuff.com/2011/07/lazy-sysadmin/%5B/url%5D
Wow, nice one!
Where's the forward button for All_Clients 😉
July 22, 2011 at 9:13 am
Why can't you use the web interface? You could delete the root folder and everything would be gone (including permissions).
July 22, 2011 at 8:26 am
It doesn't, but I use it for clarity.
The default value is NULL when the else is not used.
It would yield the same results either way.
Now...
July 22, 2011 at 7:42 am
HowardW (7/22/2011)
BEGIN TRY
DECLARE @sql VARCHAR (8000)
SET @sql='INSERT INTO table2 SELECT * FROM table1'
EXEC(@sql)
END TRY
BEGIN CATCH
print 'There was an...
July 22, 2011 at 6:26 am
I'd do a select into from excel to temp table. Then validate that the columns match in qty, size and data types. Then I'd import to the real...
July 22, 2011 at 6:21 am
raztos (7/22/2011)
Thanks for advice. But there is no another application over it. It's pure SQL script.
I'm guessing dba generated audit triggers?
If not, what are you trying to do? I...
July 22, 2011 at 6:12 am
try catch from the calling application would be my only guess. I never had to do deal with this.
July 22, 2011 at 6:02 am
Tom.Thomson (7/22/2011)
Ninja's_RGR'us (7/22/2011)
Tom.Thomson (7/22/2011)
tilew-948340 (7/22/2011)
I have SQL 2008 (but on XP professional for learning - not on a server machine - Would that make a difference?)
Yes, it makes a difference....
July 22, 2011 at 5:54 am
Because that code is never executed. That error is found and thrown at compile time (not sure if this is the exact term).
July 22, 2011 at 5:50 am
bddupree (7/22/2011)
The workaround is to set the InteractiveHeight =...
July 22, 2011 at 5:47 am
That's why I like mine better :-D.
No seriously I think we should come up with the top 3-5 sites and then average those reports (expected salary), then go in the...
July 22, 2011 at 5:43 am
Viewing 15 posts - 4,561 through 4,575 (of 18,926 total)