Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,971 through 38,985 (of 59,098 total)

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
RE: What is the best way to Archive SQL Server 2005 database?

Build "intermediate" tables to hold the PK's of all rows affected for each table. That will allow you to work unimpeded and without crushing production until you're ready to...
--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:47 pm

#1148767
RE: How to calculate ranks or position?

Nuts (4/8/2010)
Hi Guys
I have calculated top 20 tests from my table and here is the result
Test_name year
test1 ...
--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:38 pm

#1148762
RE: Update a column but only part of the text

TRACEY-320982 (4/8/2010)
Worked a treat and replaced it anywhere it found it in the string.
Thank you so much got a hugh update to do.
What does the 1 mean ?
(CHARINDEX('00001', column, 1)
My...
--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:36 pm

#1148760
RE: Frequently fragmented indexes

JDixon-385826 (4/8/2010)
fill factor 80 seems a little low - I would review the fill factor you are most likely cauing more page splits than needed
A low fill factor will prevent...
--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:15 pm

#1148754

Viewing 15 posts - 38,971 through 38,985 (of 59,098 total)