Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,991 through 40,005 (of 59,072 total)

RE: Stored Proc with table variables running very slow?

Another good idea. Thanks Wayne. Just curious though... have you ever used it that way?
--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)

February 1, 2010 at 9:00 pm

#1112063
RE: Need to break up a single row into multiple rows

Why wouldn't UNPIVOT (maybe, more than one) do the job here?
--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)

February 1, 2010 at 8:59 pm

#1112062
RE: Keeping It All In Memory

It's ironic... as someone once said, "The more things change, the more they stay the same". Holy shades of "RAM DISK", Batman! 😛
--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)

February 1, 2010 at 8:55 pm

#1112061
RE: How do I do an update/insert to certain fields in a certain order?

mohaminho10 (2/1/2010)
It is actually going to update more that 5 DB's...the total runs to about 25 DB's.
Does anyone have a sample code that I can take a look at?
Thanks
Simple...
--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)

February 1, 2010 at 6:28 pm

#1112038
RE: Physically remove record

Rebuild the clustered indexes, shrink the MDF, rebuild the clustered indexes again. Won't help the LDF, though.
As a side bar, unless these so-called "space cleaners" do overwrites with all...
--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)

February 1, 2010 at 6:25 pm

#1112037
RE: backup selected month from database

Ummmm.... what would be so bad with doing a BCP "Native" export for the month data involved? It would simplify things quite a bit.
--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)

February 1, 2010 at 6:00 pm

#1112032
RE: Repeating data in union query

Absolutely. See the following link. Almost exactly what you need...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

February 1, 2010 at 5:51 pm

#1112027
RE: Is it possible to use SQL Server Profiler and filter by user?

Would the default trace do what you want???
Also, I'm curious... is this a requirement to meet a "spec" for something like SOX compliance or do you just distrust your DBAs?...
--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)

February 1, 2010 at 5:47 pm

#1112026
RE: Why moving a database slowed it down a lot?

If i have to move databases from one machine to another, I also make the assumption that I need to do at least the daily maintenance of defragging/rebuiding indexes 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)

February 1, 2010 at 5:24 pm

#1112019
RE: Why moving a database slowed it down a lot?

george sibbald (2/1/2010)
Steve Jones - Editor (2/1/2010)
If you're using RDP, network isn't an issue.
Stats should move, but as Jeff mentioned, they often don't seem to in a backup/restore.
I thought 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)

February 1, 2010 at 5:16 pm

#1112018
RE: Indexing fields for JOINS and WHERE

Digs (2/1/2010)
A sort order for an Index..
Is that wise ???
For example I have one column filled with BIT or -1 or 0
Shouldnt need to sort that !
When is it wise...
--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)

February 1, 2010 at 5:12 pm

#1112016
RE: Indexing fields for JOINS and WHERE

John Rowan (2/1/2010)
Best practice is to index your FK columns for join performance.
CREATE INDEX <index name> ON <table name>(<column name>)
The FK's should probably be on the PK of the "remote...
--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)

February 1, 2010 at 5:11 pm

#1112015
RE: Indexing a Large Table

GilaMonster (2/1/2010)
Please post the query, table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
This will probably be something fairly easy to fix but unless you can help us help...
--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)

February 1, 2010 at 5:09 pm

#1112014
RE: ALTER a HUGE TABLE

First, table partitioning is an "Enterprise Edition" option. If you don't have the "Enterprise Edition", it's not an option.
If you don't have the "Enterpise Edition", you could make 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)

February 1, 2010 at 4:57 pm

#1112013
RE: Deciding whether adding RAM will help performance

I'm not a hardware person by any means but if the server can actually take more memory and SQL Server can actually use it (meaning that both the OS and...
--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)

February 1, 2010 at 4:38 pm

#1112010

Viewing 15 posts - 39,991 through 40,005 (of 59,072 total)