Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,651 through 49,665 (of 59,091 total)

RE: dropping tables where rowcount is zero

You can get an accurate rowcount from sys.indexes if you first run DBCC UpdateUsage(0)
It'll be a lot faster than getting a row count from every table in a database 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)

June 26, 2008 at 7:20 pm

#835075
RE: BULK INSERT and embedded commas

Yes... you need to (must) use a BCP Format file to do this with Bulk Insert... the double-quote part of the delimiter you want (two charters... either ," 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)

June 26, 2008 at 7:14 pm

#835073
RE: Need UDF that removes consecutive repeating characters from string

o2srule (6/26/2008)
Here's what I came up with but it seems kind of kludgy, although it works. It's limited to strings that are 255 in length. I'd like it 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)

June 26, 2008 at 7:05 pm

#835071
RE: Export SQL Database to flat file with header(column) name

OSQL utility might be better... it will do everything that SQL Server will do... ISQL doesn't have all the features (if I remember correctly).
--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)

June 26, 2008 at 6:45 pm

#835068
RE: Datetime

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0),
GETDATE()-DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)
--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)

June 26, 2008 at 6:36 pm

#835063
RE: Do I need more memory?

jjssilva (6/26/2008)
Check Buffer Cache values. Also, how big are the Databases?
The DB shouldn't take more than 80% of the available RAM.
So... what do you do when you run against 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)

June 26, 2008 at 6:34 pm

#835062
RE: Parameter list query - peformance 32bit vs 64bit

Mark... does your Tally table have a clustered PK on it?
--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)

June 26, 2008 at 6:28 pm

#835061
RE: what date format is this?

Heh... no problem... if you think no coffee is bad, I'm trying to quit smoking... got anyone you want to take to a porkchop dinner? 😀
--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)

June 26, 2008 at 6:07 pm

#835057
RE: Delete all records in database older than 2 years

toniupstny (6/26/2008)
You might want to determine if there might be any reason (legal requirements or self-preservation) to keep an archive of the deleted records in a separate database. 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)

June 26, 2008 at 5:52 pm

#835054
RE: For loop in sql server

venki (6/26/2008)
Especially Jef and Pduplessis,
Heh... I think it's a bit funny that you can spell "Pduplessis" correctly, but not "Jeff"... 😛
--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)

June 26, 2008 at 5:47 pm

#835052
RE: For loop in sql server

LEFT(columnname,50)
--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)

June 26, 2008 at 5:44 pm

#835051
RE: Query optimization

Yep... "Read Committed" is the default on most of the other editions (At least Standard, Enterprise, and Developer's Editions... dunno about the others). Thanks for the tip on 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)

June 26, 2008 at 5:43 pm

#835050
RE: select data and display in different coulumns

jthomastx (6/26/2008)
I actually have a similar question. I have a table that contains customer_id, customer_Fname, Contact_date, Contact_type. In running a query showing all contact dates / times 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)

June 26, 2008 at 5:32 pm

#835048
RE: Handling hirarchy in tables

GSquared (6/26/2008)
If the hierarchy is relatively static (doesn't change often), you might want to look up "nested sets" online. It does hierarchies MUCH faster than CTEs or other methods....
--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)

June 26, 2008 at 5:24 pm

#835046
RE: concern is correct - not just dba's but developers

Steve Jones - Editor (6/26/2008)
I think you need to stop looking at design because people are always in a hurry. The developers don't want to do a bad job, but...
--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)

June 26, 2008 at 5:22 pm

#835045

Viewing 15 posts - 49,651 through 49,665 (of 59,091 total)