Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,816 through 31,830 (of 59,099 total)

RE: using select into and controlling varchar sizes

cafescott (11/29/2011)
Welsh Corgi, thanks for the suggestion. I am reluctant to change to the insert-into method because I think it will take longer overall.
Ironically, you've shot yourself 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)

November 30, 2011 at 6:33 pm

#1415005
RE: Percentile function

dva2007 (11/30/2011)
hi,
it seems SQL 2012 had new function called PERCENTILE_DISC() which will find out the percentile.
http://blog.sqlauthority.com/2011/11/22/sql-server-introduction-to-percentile_disc-analytic-functions-introduced-in-sql-server-2012/
Do we have alternative function in SQL 2008 to do the same?
thanks,
Vijay
If I'm understanding...
--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 30, 2011 at 5:44 pm

#1414993
RE: Getting Last modified record from table

Actually, there's a great way to track it without a trigger if you can add a column as Kingston suggested. The difference is that you would use the TIMESTAMP...
--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 30, 2011 at 6:17 am

#1414613
RE: Add a default to a column

Steve Jones - SSC Editor (11/29/2011)
Yes, and Yes. We want to expand and cover things that are in BOL in a different way. A practical use for this in 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 30, 2011 at 6:09 am

#1414609
RE: Enable autogrowth for databases in SQL Server

Sorry Steve... I was just having a little fun about loops there. I just thought it a bit ironic that someone was saying it was hard to loop in...
--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 30, 2011 at 4:40 am

#1414568
RE: ANSI_PADDING affects storage but not QUERIES <OR> Trailing spaces ignored in WHERE clause

As ANSI_PADDING affects the storage of the data, I thought it would also have similar affects to comparisons as well, but it seems not.
Correct. It has no affect 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)

November 29, 2011 at 8:57 pm

#1414421
RE: Add a default to a column

Since this is very well documented in Books Online, I have to ask, do you still want an article on this and, if so, should it be more of 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 29, 2011 at 7:01 pm

#1414410
RE: SSIS - FTP Task - Send Files

Steve,
Do you or Red Gate have an FTP test site we could send and retrieve files to and from?
--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 29, 2011 at 6:36 pm

#1414408
RE: advice on archiving data

Evil Kraig F (11/29/2011)
Jeff Moden (11/21/2011)
Evil Kraig F (11/21/2011)
Any SQL services or tools to aid in this?
Not really.
What about table partitioning or even partitioned views?
You're correct, Jeff, I'm just concerned...
--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 29, 2011 at 6:26 pm

#1414405
RE: Enable autogrowth for databases in SQL Server

opc.three (11/29/2011)
Taking it a step further we can easily employ PowerShell and WMI to discover all SQL Server instances on our network without relying on the SQL Browser. If anyone...
--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 29, 2011 at 6:19 pm

#1414404
RE: Enable autogrowth for databases in SQL Server

Steve Jones - SSC Editor (11/29/2011)
I tend to agree with Bruce that Powershell is a nice multi-server tool. It's easily deployable to multiple machines, and it allows you to potentially...
--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 29, 2011 at 6:16 pm

#1414403
RE: table performance

Agh... almost forgot to ask... are there any triggers on this table?
--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 29, 2011 at 6:11 am

#1413986
RE: table performance

I don't see any huge problems with that DDL that may cause INSERTs or SELECTs to be so slow. That pretty much isolates things to the code doing 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)

November 29, 2011 at 6:11 am

#1413984
RE: To change datetype varchar(14)

Cadavre (11/29/2011)
But I prefer CLR when I have to do something like this. The RegEx function in .Net is much faster at validating this sort of thing (I'll knock 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)

November 29, 2011 at 5:36 am

#1413952
RE: To change datetype varchar(14)

rashid_alavi (11/29/2011)
hi All,
I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, 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)

November 29, 2011 at 5:31 am

#1413948

Viewing 15 posts - 31,816 through 31,830 (of 59,099 total)