Jeff Moden

Forum Replies Created

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

RE: How to get the list of dates between two dates usind sql query?

schuppe (6/26/2008)
create table testtable (startdate datetime, enddate datetime)
insert into testtable values(getdate(), dateadd(day, 5, getdate()));
with test (startdate, enddate) as
(select startdate, enddate from testtable
union all
select dateadd(day, 1, test.startdate), test.enddate...
--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:56 pm

#835089
RE: How to get the list of dates between two dates usind sql query?

Michael Earl (6/26/2008)
Search for "Tally Table" on this site and you will find some articles by Jeff about how to do this. He's a pretty smart guy and his...
--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:52 pm

#835087
RE: Making duplicates unique

GSquared (6/26/2008)
For 2000, take a look at Jeff Moden's Running Totals article on this site. You should be able to use a variation on that. Bit more complex...
--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:46 pm

#835084
RE: Sample Data Required

In that same vein...
DROP TABLE JBMTest
GO
--===== Create and populate a 1,000,000 row test table.
-- Column "RowNum" has a range of 1 to 1,000,000 unique numbers
...
--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:40 pm

#835083
RE: Grouping GROUP BY subtotals

First, the warning about nulls is just that... a warning to let you know that some rows had nulls and they were ignored. You can suppress that message 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:37 pm

#835082
RE: Need Some Queries

Heh... rowcount can be wrong in sysindexes unless you run the correct DBCC command to update them... that's a hint... look it up in Books Online.
--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:31 pm

#835080
RE: no parallelism in the execution plan - why?

I dunno... I'm thinking that's about the 100th 64 bit related performance problem that I've seen in the last month or so... I'm thinking the 64 bit version is like...
--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:29 pm

#835079
RE: Invoking a C# exe from a package crashes the exe

With the information given, I would say the xyz.exe has a problem that needs to be repaired. Just because it compiles doesn't mean it's right... 😉
--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:26 pm

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

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