Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,216 through 19,230 (of 59,072 total)

RE: Table Paritioning

Welsh Corgi (11/9/2015)
I have written a Stored Procedure to Archive Tables.
I have been asked to Partition the tables.
Would I be better off to hold off on the archiving and just...
--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 9, 2015 at 4:42 pm

#1838725
RE: How to Add a Drive as a Clustered Physical Disk Resource in Windows

Now we're talking. Thanks for posting some feedback, folks!
--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 9, 2015 at 4:39 pm

#1838724
RE: DY

Rich Mechaber (11/9/2015)
Jeff Moden (11/6/2015)
sknox (11/6/2015)
Luis Cazares (11/6/2015)
Rich Mechaber (11/6/2015)
Aaron Bertrand had a nice blog about this: scroll down for "Pop Quiz" and see if you still think DATEPART abbreviations...
--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 9, 2015 at 7:30 am

#1838557
RE: How to Add a Drive as a Clustered Physical Disk Resource in Windows

I hate it when people give an article 1 star without saying why. It gives no one the chance to improve or avoid. Incredibly, I've never had 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)

November 9, 2015 at 5:30 am

#1838514
RE: A big thank you

Grant Fritchey (11/8/2015)
Agreed. Can't let the perfect become the enemy of the good. That said, when you're introducing technical debt, know that.
Heh... I was going to say "Good enough usually...
--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 8, 2015 at 7:56 pm

#1838465
RE: Exporting column using xp_cmdshell to plain text file error

SoHelpMeCodd (11/7/2015)
The problem is -c, which is /character mode. BCP in /character mode expects to be passed a /format file (or it will interactively prompt you for the output's format,...
--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 8, 2015 at 7:48 pm

#1838464
RE: Find last working day based on given start date and number of working days

This is one of those places where a Calendar Table really shines. Here's a proc to build one (including standard USA holidays that my company observes). NOTICE 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)

November 8, 2015 at 7:30 pm

#1838463
RE: Exporting column using xp_cmdshell to plain text file error

I'm thinking that there are two possibilities here.
1. If you have sysadmin privs, xp_CmdShell doesn't run as you. It runs as the service login for SQL Server and,...
--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 7, 2015 at 11:56 am

#1838421
RE: DateAdd overflow using Numbers Table

ArcticEd32 (11/3/2015)
I have a table "Numbers" with a single int field "N". The records go from 0 through 100,000.
I'm trying to generate a sequential list of months starting with...
--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 7, 2015 at 11:50 am

#1838420
RE: Creating a PDF from a Stored Procedure

srinivassrivas (11/6/2015)
Its not working pdf file is not generating
please help.
Where did you look for the file?
--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 6, 2015 at 5:58 pm

#1838385
RE: Pipe Delimmeted Data To Shred Into A Table

xxxy2k (11/6/2015)
Hi,
Need help to shred pipe delimmited data into a table, cant seem to find anything that will help me do this.
for example the data looks roughly like this
234|2015-6-11|234aa|
ID1|a|A||234|ASDFASDF|2015-06-11|A|s||NULL|||||TEST|TEST|TEST|TEST|1543211
ID2|B|A||234|ASDFASDF|2015-06-11|A|s||NULL|||||TEST|TEST|TEST|TEST|1234
I 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 6, 2015 at 5:49 pm

#1838384
RE: How to fix "Divide by zero error" in SQL Server

Luis Cazares (11/6/2015)
priterande (11/5/2015)
select COALESCE(MIN(Act) / NULLIF(MAX(Act),0), 0) as minvsmaxAct from table_name
This is what I usually do, except that I don't reply to 5 year old threads. :w00t:
I usually don't...
--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 6, 2015 at 5:37 pm

#1838382
RE: How to fix "Divide by zero error" in SQL Server

nigel. (2/26/2010)
Guys you're posting answers to a question asked in 2004. I hope they've fixed the problem by now. :w00t:
It's now more than a decade and if they're anything like...
--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 6, 2015 at 5:36 pm

#1838381
RE: How to fix "Divide by zero error" in SQL Server

Derrick Leggett (6/22/2004)
Don't divide by zero. <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'> You need to figure out where you are doing this and fix it.
BWAAA-HAAA!!!! Even 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)

November 6, 2015 at 5:33 pm

#1838380
RE: need tsql help on sql job

pietlinden (11/6/2015)
I would start by adding some code to log the start time and end time of your jobs in a table somewhere. Then you can query that for...
--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 6, 2015 at 5:30 pm

#1838379

Viewing 15 posts - 19,216 through 19,230 (of 59,072 total)