Viewing 15 posts - 38,941 through 38,955 (of 59,072 total)
Welsh Corgi (4/8/2010)
Jeff,I just read your response and I appreciate you input.
Regards,
Welsh
Thanks, Welsh.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 5:17 pm
CirquedeSQLeil (4/9/2010)
Yes Odd number of Board members. I don't think it should take more than three people though.
Heh... just odd bored members? 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 3:50 pm
Kathi Kellenberger (4/9/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2010 at 3:28 pm
I don't know if I missed it somewhere, but I believe there needs to be an "MCJ T-SQL" somewhere in the mix.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 10:23 pm
Perfect... all the more reason for me to [font="Arial Black"]not [/font]trust people with certifications.:Whistling:
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 10:06 pm
As a side bar, try the following and imagine the possibilities because it doesn't require xp_CmdShell (a lot of DBA's won't turn it on)...
EXEC Master.dbo.xp_Dirtree 'E:\Pras',1,1
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 10:01 pm
Ok... I claim extreme ignorance about 2k8 installations but I'm getting ready to do a test install. What do you good folks mean by "slipstreaming" in the context of...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 9:55 pm
As a side bar, I'm not sure why you want to avoid dynamic SQL for this... it's not slow when used for batch processess... just for bazillions of single row...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 9:52 pm
-Shree (4/8/2010)
Am trying to convert tsv file to table for performance analysis, but am unable to do that:angry:
have tried
1. Converting TSV - to Excel- and then importing...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 9:48 pm
Wouldn't it be a heck of a lot easier to create a couple of synonyms in a new database that had almost no space allocated to it?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 9:43 pm
Stefan_G (4/8/2010)
You should also change the query so the SQL server understands that you are really...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 9:34 pm
As a side bar, try this and imagine the possibilities... 😉
EXEC Master.dbo.xp_Dirtree 'E:\temp',1,1
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 9:26 pm
As a side bar, it sounds like you may be trying to keep a "gapless" IDENTITY column. That's normally a highly counter productive thing to do. Please explain...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 8:57 pm
BaldingLoopMan (4/8/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 8:54 pm
{edit} Sorry, posted to wrong thread...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 8, 2010 at 8:49 pm
Viewing 15 posts - 38,941 through 38,955 (of 59,072 total)