Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,076 through 24,090 (of 59,099 total)

RE: List Files In Directory Using SQL

I know... old thread. 😉
Just want to correct that last post. xp_CmdShell support names with spaces in them just like DOS does... you have to put double-quotes around 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)

March 24, 2014 at 10:04 pm

#1699720
RE: need query unpivot in sql servr

Step 1 would be to make it easy for someone to give you a working, tested, coded solution. Please see the first link under "Helpful Links" in my signature...
--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)

March 24, 2014 at 8:40 pm

#1699717
RE: Converting sequential time records into IN and OUT times

pssudarshan (3/24/2014)
Hi,
We have a Time & Attendance application that stores the time punched by each employee in a sequential format. There is no indication as to whether the time...
--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)

March 24, 2014 at 8:25 pm

#1699716
RE: Auditor Rant

Grant Fritchey (3/24/2014)
We're going to need you to come in this weekend to work on those TPS reports, mmmkay?
So long as I can keep the red SwingLine stapler...
--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)

March 24, 2014 at 8:12 pm

#1699714
RE: Ordering items by hierarchy without RBAR

Sure... you could do a 4 way self join but that's hardcoding levels.
Recursion isn't so bad here. It will do things by level, not by row.
--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)

March 24, 2014 at 2:32 pm

#1699679
RE: missing .mdf and .ldf database file after hard drive crash

hwp (3/24/2014)
Sorry, a total noob here.
If the data is valuable, then I suggest you stop all efforts and get a local pro in there to help you. 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)

March 24, 2014 at 2:30 pm

#1699677
RE: Auditor Rant

David O (3/24/2014)
Does anyone else every have day's when they feel like there the audit team's secretary (I could you another word but it is a family show)?
Run 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)

March 24, 2014 at 2:25 pm

#1699675
RE: Getting My List of Databases as an array?

Ooooooo, be careful. I've been through this especially wth the diskspace problems that you mention.
If you delete a backup before you have a new one and the backup job...
--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)

March 24, 2014 at 2:19 pm

#1699673
RE: Show data toEnd User Un-Interrupted.

TomThomson (2/11/2014)
happycat59 (2/10/2014)
Rather than dropping/renaming tables, how about using the ALTER TABLE...SWITCH command. It will not leave you with any period when the table doesn't exist (SQL manages 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)

March 24, 2014 at 11:47 am

#1699642
RE: Getting My List of Databases as an array?

I have to sk... why are you using PoSH instad of just T-SQL for this? It's an easy task in T-SQL.
--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)

March 24, 2014 at 11:37 am

#1699639
RE: what is SSD?

Koen Verbeeck (3/24/2014)
atulyan.aries (3/23/2014)
Hi,
can anyone please tell me what is meant by ssd and how sql uses this. Also can temp db be moved to ssd
Yes, tempdb can be moved...
--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)

March 24, 2014 at 7:13 am

#1699514
RE: Fast inserting\reading\deleting of millions of records

So do you still need the DISTINCT?
--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)

March 24, 2014 at 7:01 am

#1699511
RE: Working with stored text file in TSQL

If that's the case, then you could use SQLBULKCOPY in C# to load the rows into the database in batches much like BCP or BULK INSERT would. That will...
--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)

March 24, 2014 at 5:19 am

#1699469
RE: Fast inserting\reading\deleting of millions of records

I can't speak to the INSERTs but the accidental CROSS JOIN in the SELECT code will beat the hell out of the hardware making it look like a hardware problem.
--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)

March 24, 2014 at 5:16 am

#1699467
RE: Reaping the benefits of the Window functions in T-SQL

dwain.c (3/24/2014)
Interesting article. I'm curious to see what comments Jeff has about it.
Eirikur asked me to review it (seems like a couple/three months ago) and I'm tickled to death...
--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)

March 24, 2014 at 5:02 am

#1699460

Viewing 15 posts - 24,076 through 24,090 (of 59,099 total)