Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,941 through 38,955 (of 59,072 total)

RE: Index suggestion for VERY large table

Welsh Corgi (4/8/2010)
Jeff,
I just read your response and I appreciate you input.
Regards,
Welsh
Thanks, Welsh.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2010 at 5:17 pm

#1149428
RE: MCJ - The Missing Link

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2010 at 3:50 pm

#1149405
RE: Slipstreaming SP1 and Enterprise edition

Kathi Kellenberger (4/9/2010)
Take a look at the links I posted. Slipstreaming is combining the service pack with the RTM media. If all goes well, you don't have to apply the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2010 at 3:28 pm

#1149395
RE: MCJ - The Missing Link

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 10:23 pm

#1148797
RE: testpassport ensure passing 199-01 exam

Perfect... all the more reason for me to [font="Arial Black"]not [/font]trust people with certifications.:Whistling:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 10:06 pm

#1148793
RE: Bulk Insert more than one CSV file

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 10:01 pm

#1148788
RE: Slipstreaming SP1 and Enterprise edition

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 9:55 pm

#1148787
RE: Counting non-blank columns

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 9:52 pm

#1148786
RE: TSV to Table

-Shree (4/8/2010)
Hi,
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 9:48 pm

#1148783
RE: Allow SELECT on Tables for Specified Database

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 9:43 pm

#1148781
RE: Index suggestion for VERY large table

Stefan_G (4/8/2010)
You should define a clustered index on GeoID, ProductID, AsOf just as you suggested yourself.
You should also change the query so the SQL server understands that you are really...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 9:34 pm

#1148779
RE: Is it possible to findout the files in SQl server?

As a side bar, try this and imagine the possibilities... 😉
EXEC Master.dbo.xp_Dirtree 'E:\temp',1,1
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 9:26 pm

#1148777
RE: how to code if not exists(then set identity and then insert

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 8:57 pm

#1148772
RE: Does sql server have something that is similar to open query but more functional?

BaldingLoopMan (4/8/2010)
So if i use link server i would lose the dynamic nature. Actually there are some instanceswere i've had to use link server but i'd like to have all...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 8:54 pm

#1148771
RE: Any tried & true approaches for automating critical data change requests?

{edit} Sorry, posted to wrong thread...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2010 at 8:49 pm

#1148769

Viewing 15 posts - 38,941 through 38,955 (of 59,072 total)