Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,281 through 41,295 (of 59,069 total)

RE: How does a View work?

GSquared (11/4/2009)
That means, no, it doesn't pull all the rows and then filter them. The query engine is smarter than that.
Ummm... not always true, Gus. If a view...
--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)

November 4, 2009 at 10:36 pm

#1075157
RE: How to convert some Access SQL into TSQL?

george.greiner (11/3/2009)
Ok cool I will definitely be looking into that code later on to better understand and speed up what I am doing! Really appreciate it guys! Thanks.
Most 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)

November 4, 2009 at 10:28 pm

#1075152
RE: Output to grid file

alark (11/4/2009)
Hi,
I created a shell script (Windows XP) that runs a stored procedure (SQL-2005) using OSQL ... and directs output to a file. The problem is that the file is...
--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)

November 4, 2009 at 10:20 pm

#1075146
RE: how to find 3days before date from prasent date

Yes there is... please see DATEADD in Books Online. Yeah... you could just subtract 3 from a DATETIME datatype, but that won't work on some of the new DATE...
--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)

November 4, 2009 at 10:15 pm

#1075144
RE: Inspiring Change

I'd encourage the rest of you to give it a try and see if you can inspire a young girl, a minority, or a child you know to consider a...
--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)

November 4, 2009 at 10:05 pm

#1075141
RE: Looping through a directory for sub-directories' names

Build a Temp table to accept results from the following (using Insert/Exec) and then query the Temp table...
EXEC dbo.xp_DirTree 'file path or UNC',1,1
Works in 2k, 2k5, and 2k8. ...
--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)

November 4, 2009 at 8:26 pm

#1075122
RE: Which 3rd Party performance tool do you use?

Indianrock (11/4/2009)
Which tool do you use and why?
SQL Server Profiler, and a healthy dose of grey matter.
Why were others ruled out?
They're available for use on every SQL Server (not...
--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)

November 4, 2009 at 8:18 pm

#1075120
RE: Preventing Table Locks: Are cursors a good idea?

huston.dunlap (11/3/2009)
We are creating some new update scripts that will be run on a live database. The scripts will be running on the main table for the database, so concurrency...
--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)

November 4, 2009 at 7:21 pm

#1075109
RE: Money vs. Decimal Data type

repent_kog_is_near (11/2/2009)
Jeff
Let me try to summarize you:
*Bigger the precision (is it and/or scale), better the accuracy,especially in multiplication by a big number (Example: 2.45454545 (precision 9;scale 2) is more accurate...
--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)

November 4, 2009 at 6:47 pm

#1075107
RE: Are the posted questions getting worse?

Alvin Ramard (11/4/2009)
Jeff Moden (11/4/2009)
GilaMonster (11/4/2009)
Roy Ernest (11/4/2009)
I wonder how the Kilt day is going in PASS... 🙂
Interestingly. Photos later.
Heh.... gives new meaning to the phrase "What's Up?" 😉
Some 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)

November 4, 2009 at 6:23 pm

#1075105
RE: Are the posted questions getting worse?

GilaMonster (11/4/2009)
Roy Ernest (11/4/2009)
I wonder how the Kilt day is going in PASS... 🙂
Interestingly. Photos later.
Heh.... gives new meaning to the phrase "What's Up?" 😉
--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)

November 4, 2009 at 11:44 am

#1074957
RE: ssis and ssrs interview questions

Greg Edwards-268690 (11/3/2009)
Jeff Moden (11/2/2009)
pleasehelpme (11/2/2009)
gilamonster,
it's not your business how people like to answer the questions in the interview. Stop whining ok, you are annoying.
Heh... nah... what's realy annoying is...
--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)

November 3, 2009 at 10:54 pm

#1074676
RE: Finding Space occupied by a row

Ah... thanks for the feedback on what you actually need it for. It's a rare pleasure to get that kind of feedback.
I'm in the process of rebuilding my computer...
--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)

November 3, 2009 at 6:35 pm

#1074627
RE: The Multi-valued Parameters problem in Reporting Services

Naeem_Khan (11/3/2009)
Hi
I have multi value parameter:
a
b
c,e
f,m
d
The selected values are returned as b,c,e,f,m
The UDF returns 5 different items when it should return 3 items. The problem is that the values have...
--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)

November 3, 2009 at 5:40 am

#1074220
RE: Finding Space occupied by a row

This is about the 3rd time this question has been asked in as many days... why do you need to know this?
--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)

November 3, 2009 at 5:31 am

#1074218

Viewing 15 posts - 41,281 through 41,295 (of 59,069 total)