Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,571 through 36,585 (of 59,072 total)

RE: fn_fixeddrives() : an alternative for xp_fixeddrives

SQueaLer1 (9/21/2010)
Hi David,
I appreciate the concept but I have to disagree with the approach. We programmers can come up with a lot of "nice" solutions, but they don't always work...
--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)

September 21, 2010 at 6:26 pm

#1225291
RE: SQL Server 2008 - CItrix environment

We ran into this... I don't know what the actual fix was because the boys in OPs took care of it but it had to do with the "number 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)

September 21, 2010 at 7:32 am

#1224800
RE: where can I start with performance Improvement for SQL 2008

Tim Parker (9/20/2010)
Well you have already started with the first thing that needs to be addressed when improving performance in a database. In many cases, regardless of memory or...
--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)

September 21, 2010 at 7:29 am

#1224797
RE: Need to zip and move C2 level audit files

shew (9/21/2010)
ps. (9/21/2010)
Hey Jeff, the problem will arise when there are multiple files on the folder and he tries to zip them in a loop. there will be seperate wipzip...
--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)

September 21, 2010 at 7:21 am

#1224790
RE: Need to zip and move C2 level audit files

ps. (9/21/2010)
Jeff Moden (9/20/2010)
Ah... that may be the key. Is there any problem with you just zipping one file at a time instead of putting a bunch of files...
--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)

September 21, 2010 at 7:17 am

#1224783
RE: GetDate() not working

I know that Gail and Steve have done it correctly. I'm just amazed at the number of, ummmm.... shall we say, "myths" that have come up on this one....
--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)

September 21, 2010 at 7:11 am

#1224774
RE: Need to zip and move C2 level audit files

Ah... that may be the key. Is there any problem with you just zipping one file at a time instead of putting a bunch of files in a single...
--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)

September 20, 2010 at 10:56 pm

#1224511
RE: Need to zip and move C2 level audit files

shew (9/20/2010)
Jeff Moden (9/19/2010)Use to work for a "little" DOD shop known as Raytheon. 😛
Little? LOL
The only way that I can think of to make this synchronus is based on...
--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)

September 20, 2010 at 10:51 pm

#1224508
RE: How to dump a table from a Prod database to a dev database

sqlbuddy123 (9/20/2010)
Deprecated in SQL 2005, replaced by SSIS, should not be used for new development, will be removed in a future version of SQL Server.
________________________________________
Gail Shaw
We walk in 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)

September 20, 2010 at 10:42 pm

#1224504
RE: Best practices are really the best (fastest) solution?

The second most important part of optimizing is to know how long [font="Arial Black"]each part [/font]took using the old way and how long it takes using the new way. ...
--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)

September 20, 2010 at 9:54 pm

#1224488
RE: Dynamic columns in ssrs

Gosh... why do people both bite off more than they can chew and then wait until the deadline is damned near on them? Here's how to do it... good...
--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)

September 20, 2010 at 9:50 pm

#1224487
RE: bcp question

but this is giving errors
It sure would be nice if you'd post exactly what those errors are. 😉
--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)

September 20, 2010 at 9:03 pm

#1224478
RE: concatenating CASE stmt results

I don't like the short version at all because it "lies". If you expand the code it actually executes against variables, you find a big surprise. And if...
--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)

September 20, 2010 at 8:54 pm

#1224474
RE: I need some help with a test, please.

bitbucket-25253 (9/20/2010)
Jeff Moden (9/20/2010)
P.S. I really want to know when you took up mind-reading, Ron. I was about to post and ask for a full run like that. ...
--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)

September 20, 2010 at 7:21 pm

#1224464
RE: I need some help with a test, please.

gah (9/20/2010)
Jeff Moden (9/20/2010)
Thank you one an all for your help. 🙂
Jeff...you are more than welcome, it was the least I could do to repay you for the amount 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)

September 20, 2010 at 4:55 pm

#1224440

Viewing 15 posts - 36,571 through 36,585 (of 59,072 total)