Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,886 through 36,900 (of 59,098 total)

RE: Blocking on tempdb system tables

PaulB-TheOneAndOnly (9/12/2010)
sporoy (9/12/2010)
Hi, we are having blocking issues with tempdb database, blocking transaction is open for 30 minutes and has create table #Table statements in it, because of...
--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)

September 12, 2010 at 9:09 pm

#1219818
RE: Using DateDiff to calculate days before a Birthday

kenkob (9/12/2010)
Jeff,
After a little trouble I have got it working. When I attempted to use it as a SqlCe CommandText string surrounded by inverted commas, I was always...
--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)

September 12, 2010 at 9:04 pm

#1219813
RE: Creating large semi-random data sets without cursors

Here's a start... my standard million row test table. There's a special column in the following that you should look for, as well. You'll recognize it. Should...
--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)

September 12, 2010 at 9:00 pm

#1219812
RE: XML "CSV" Splitter

I'm amazed... to split 10,000 rows with 10 random elements each, this XML method takes more than 14 seconds on my humble desktop. A While Loop driven function only...
--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)

September 12, 2010 at 5:41 pm

#1219799
RE: Need to compare two columns

Carefull folks... ISDATE isn't all that you believe it is...

SELECT ISDATE('2010'), CAST('2010' AS DATETIME),
ISDATE('201006'), CAST('201006' AS DATETIME),
...
--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)

September 12, 2010 at 2:45 pm

#1219769
RE: Create, Rename, Delete file folder thru SQL

Steve Jones - Editor (8/12/2009)
You'd be better off doing this in Powershell or VBScript and calling the script from T-SQL if you need to.
I know it's an old post 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)

September 12, 2010 at 2:00 pm

#1219762
RE: Performance testing and tuning for a beginner

Specially I learned in tuning a few things:
We should be careful about creating temporary tables, dynamic SQL and joining. Those things are the gold mine for the tuners as eliminating...
--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)

September 12, 2010 at 8:48 am

#1219724
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/10/2010)
Alvin Ramard (9/10/2010)
Jeff Moden (9/10/2010)
..... Perfect for the game we all call "life". 😛
The game of life is hard to play
I'm gonna lose it anyway
The losing...
--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)

September 10, 2010 at 7:53 pm

#1219591
RE: Poor performance when all RAM allocated, but not in use

hirro (9/10/2010)
Here is what I've gotten from Microsoft.
Looking through the plan I see that there is a difference in how SQL is generating the query plan for the same query...
--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)

September 10, 2010 at 7:52 pm

#1219590
RE: Are the posted questions getting worse?

WayneS (9/10/2010)
Jeff Moden (9/10/2010)
mtillman-921105 (9/10/2010)
The Dixie Flatline (9/10/2010)
I played a lot of Civilization. It took a while, but it finally dawned on me that the barbarians weren'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)

September 10, 2010 at 7:31 pm

#1219580
RE: Using DateDiff to calculate days before a Birthday

kenkob (9/10/2010)
Jeff,
Just entering SELECT YEAR(GETDATE()) give the error Function is not recognized by SQL Server Compact Edition of Function [Year]
Running DATEPART returned 2010
Then doing a little substitution in my...
--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)

September 10, 2010 at 7:25 pm

#1219577
RE: Tips for writing queries needed

How ironic... Lynn is in pretty much the same postion at his job right now.
--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)

September 10, 2010 at 7:21 pm

#1219575
RE: Poor performance when all RAM allocated, but not in use

hirro (9/10/2010)
Ran a test while tracking swap file disk usage.
SQL set to use 84 GB max memory
6 seconds for the query
SQL set to use 92 GB max memory
30 seconds 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)

September 10, 2010 at 7:14 pm

#1219572
RE: Poor performance when all RAM allocated, but not in use

hirro (9/10/2010)
Another interesting bit of information:
(Physical RAM Config) SQL Allocation - Time it took
(6x8GB) 48GB allocated to SQL - Query takes 6 seconds
(12x8GB) 84 GB allocated to SQL – Query...
--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)

September 10, 2010 at 7:05 pm

#1219570
RE: Poor performance when all RAM allocated, but not in use

stewartc-708166 (9/10/2010)
Jeff Moden (9/10/2010)
Of course, I could be dead wrong. 😉
I recently had the "pleasure" of troubleshooting why a UAT SQL server regularly stopped working, with error "Insufficient disk space".
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)

September 10, 2010 at 6:59 pm

#1219569

Viewing 15 posts - 36,886 through 36,900 (of 59,098 total)