Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,231 through 19,245 (of 59,098 total)

RE: Delete Specific Record

It's going to be a bit slow but something like the following will do it...
SELECT columnlist
FROM dbo.SomeTable
WHERE (SomeColumn LIKE '%[^ ] [^ ]%' 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)

November 10, 2015 at 6:35 am

#1838820
RE: Querying Yesterday

I don't recall all of the reasons/caveats offhand but I remember reading about it and then studying how it works. All I can remember is "OK then... there's 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 10, 2015 at 6:25 am

#1838815
RE: Average and mean for months / weeks values

Just to be sure, "average" and "mean" are the same thing.
For averaging over months, a lot of people will design on of several types "floating" or "rolling" averages. 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 10, 2015 at 5:43 am

#1838804
RE: Do You Have Scary Code?

Gary Varga (11/10/2015)
I joined a project part way though and got ridiculed the week when I added the first unit test project to the solution. It had 1 test.
By then...
--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 10, 2015 at 5:36 am

#1838803
RE: Cursors

tt-615680 (11/10/2015)
Thank you for your reply!
I'm trying to get some information on permissions on each databases on the server but I'm trying to get a way of retrieving the information...
--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 10, 2015 at 5:21 am

#1838800
RE: Transaction Log space issue

jdbrown239 (11/9/2015)
Hello
I have a very large table (600,000,000 rows) on which I am trying to rebuild each index.
Every time I try the log file runs out of space. Log...
--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:15 pm

#1838733
RE: Transaction Log space issue

have2much (11/9/2015)
If you need to rebuild all indexes on a table, why don't you create new table and port data to new table in batches to limit log file growth.
1....
--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:13 pm

#1838732
RE: Transaction Log space issue

Jacob Wilkins (11/9/2015)
Keep in mind sp_spaceused doesn't report the size of a clustered index as part of "index_size". If the table in question has (is) a clustered index, and you're...
--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:09 pm

#1838731
RE: Split time span into multiple records

Just to share a warning... run the following and see what's wrong in the original query...
SELECT CAST('2015-09-01 23:59:59.999' AS DATETIME);
You shouldn't try to "hit the mark" on the end...
--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:03 pm

#1838730
RE: Need help to run a Powershell from SQL Server

Shawn Melton (11/9/2015)
What is the error?
... and on which box is the "D:" drive?
--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:46 pm

#1838727
RE: SSMS does not see my NAS

I wouldn't remove it. It's saying the drive is already mapped. The question is, why it would appear otherwise.
--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:45 pm

#1838726
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

Viewing 15 posts - 19,231 through 19,245 (of 59,098 total)