Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,516 through 25,530 (of 59,099 total)

RE: Are the posted questions getting worse?

GilaMonster (10/31/2013)
Last day of freedom. Starting dev job tomorrow. Hopefully will go well...
I'm unlikely to be around much during the week from now on (at least for a while), so...
--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)

October 31, 2013 at 8:29 am

#1663078
RE: how do i find 5th working day in a month.

If you only need compatibility back to 2005, then I guess you could call the following a "simplification".
DECLARE @pMonth INT
,@pYear...
--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)

October 30, 2013 at 9:05 pm

#1662906
RE: how do i find 5th working day in a month.

As much as I love Tally Tables and as high performing as they can be, I find that pure math will frequently beat it (although I've not tested it 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)

October 30, 2013 at 8:37 pm

#1662904
RE: table with more than 1.5 Lakh record simplet query taking too much time

Keith Tate (10/30/2013)
kapil_kk (10/30/2013)
janki0430 (10/30/2013)
AssembleTrn is table with about 170157 records
when i run this query it will take about more than 1.30 minute
plesae help me in getting...
--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)

October 30, 2013 at 7:05 pm

#1662896
RE: table with more than 1.5 Lakh record simplet query taking too much time

janki0430 (10/30/2013)
AssembleTrn is table with about 170157 records
when i run this query it will take about more than 1.30 minute
plesae help me in getting recoeds in faster...
--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)

October 30, 2013 at 7:03 pm

#1662895
RE: backup file with datetime stamp

Sqlsavy (10/28/2013)
How to create backup files with datatime stamps this is to retain 2 days backups on the disk
BACKUP DATABASE [DBNAME] TO
DISK = N'D:\BACKUPs\DBNAME\DBNAME_1.bak',
DISK = N'D:\BACKUPs\DBNAME\DBNAME_2.bak',
DISK = N'D:\BACKUPs\DBNAME\DBNAME_3.bak',
DISK...
--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)

October 30, 2013 at 6:59 pm

#1662894
RE: Concatenate Rows (PowerPivot)

Please see the following article for one pretty easy method.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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)

October 30, 2013 at 6:30 pm

#1662891
RE: Query spills to tempdb with correct cardinality estimates

martin catherall (10/30/2013)
fair point Jeff, I used the term "spill to disk" to mean "spill to tempdb" - that was an error on my part.
Let me re-phrase again 🙂
Why can'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)

October 30, 2013 at 6:18 pm

#1662890
RE: longtext

LOVER OF SQL (10/30/2013)
Jeff, my problem is maximum size 8... I was tried using SSIS, but it's the same problem... I have a 180 columns and 1 million rows [font="Arial...
--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)

October 30, 2013 at 6:09 pm

#1662889
RE: Display More Than 8000 Characters (SQL Spackle)

Sorry... post deleted... I had already addressed the issue I was posting about.
--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)

October 30, 2013 at 6:02 pm

#1662888
RE: Risky Backups

From the article:
I know that some people like having the same filename every day as it makes restores simpler, especially if they've scripted things.
I realize this is a 4 year...
--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)

October 30, 2013 at 5:03 pm

#1662883
RE: Risky Backups

Miles Neale (10/30/2013)
In the old days the Ancients use to say Kiss = Keep it Simple Stupid.
BWAAA-HAAAAA!!!! Since you're a fellow "Ancient", I strongly suspect you preserve the original...
--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)

October 30, 2013 at 4:50 pm

#1662882
RE: Running Count

AronB (10/30/2013)
Thank you all for your solutions. It's greatly appreciated.
The question now would be, do you understand how and why they 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)

October 30, 2013 at 4:18 pm

#1662880
RE: Giant Logfiles (ldf) during loading data into a Memory Optimized table

If you really do have the DB in the SIMPLE Recovery Model, try SELECT/INTO or other "minimally logged" technique. Lookup "Minimally Logged" in Books Online for additional requirements 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)

October 30, 2013 at 4:17 pm

#1662879
RE: Query spills to tempdb with correct cardinality estimates

martin catherall (10/30/2013)
Why can't SQL SERVER put aside enough memory for the sort and avoid the spill to disk, there seems to be an upper limit the memory that can...
--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)

October 30, 2013 at 3:58 pm

#1662875

Viewing 15 posts - 25,516 through 25,530 (of 59,099 total)