Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,731 through 26,745 (of 59,099 total)

RE: Database Documention Tool

I agree that documentation is the first thing to take a hit if it's done at all. I also agree that extended properties are a bit of a PITA...
--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 3, 2013 at 8:23 am

#1620578
RE: BCP Utility to output contents into CSV

Sigerson (6/3/2013)
@jeff:
Thanks for the information, it answered a lot of my questions. I'm an accidental DBA at best. I never grant individual users any special privs so I...
--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 3, 2013 at 8:09 am

#1620568
RE: How to rollback an insert query on sql server ? , please suggest bit high priority .. thanks in advance

You can't "skip" mistakes using restores of any kind. You can restore up until the point in time where the mistake was made.
--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 2, 2013 at 9:44 pm

#1620372
RE: DB Reindex

To add to what the others have already cited... fragmentation is constantly happening on active systems that have any indexes that are based on non-temporally related columns... even during defragmentation...
--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 2, 2013 at 9:41 pm

#1620371
RE: get lookup data

sqlsdev (6/2/2013)
I have two tables, lets say Table 1 and Table 2 as below
Table 1:
Col1 Col2
1 _A
2 _B
3 ...
--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 2, 2013 at 9:36 pm

#1620369
RE: how to write expression for Derived Column transform

KoldCoffee (5/29/2013)
I need to filter out all records as follows:
where
[Month 01] is null 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)

June 2, 2013 at 9:27 pm

#1620368
RE: How to rollback an insert query on sql server ? , please suggest bit high priority .. thanks in advance

pietlinden (6/2/2013)
Yes, you could, but that's like killing a mosquito with a bazooka. Wrapping the statements in question in a transaction would be much less overhead and work.
Heh... 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)

June 2, 2013 at 9:20 pm

#1620367
RE: Determine the size of the changed data in a database???

Michael L John (5/30/2013)
Their big concern is bandwidth usage.
WHICH "bandwidth"? Network traffic, cpu usage, harddisk reads, writes, or overall throughput, memory I/O, time to make logfile backups, number...
--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 2, 2013 at 9:14 pm

#1620366
RE: Xml Query Performance Sql Server

And now we know why I hate XML and the bloat it brings to all facets of data. This is "progress"? :blink:
--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 2, 2013 at 9:01 pm

#1620364
RE: which one is best query?

Considering the low selectivity of the criteria, they're both going to making sucking sounds. If you index to increase their SELECT performance, they'll likely timeout on inserts 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)

June 2, 2013 at 8:50 pm

#1620363
RE: What normal form would this be considered? 2NF or 3NF?

Golfer22 (6/2/2013)
Lets say I have a table with four columns named PersonID1, PersonID2, JobTitle, and PreviousJobTitle. There is a composite primary key on PersonID1 and PersonID2. In 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)

June 2, 2013 at 8:28 pm

#1620361
RE: Best way to find certain records.

Well I'll be damned. Talk about laying waste to more than one supposed "Best Practice"! The only good thing that comes of this is that the following tests...
--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 1, 2013 at 10:52 am

#1620287
RE: Best way to find certain records.

Thanks, Graham, especially for the test harness. I'll check it out.
--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 1, 2013 at 8:04 am

#1620285
RE: BCP Utility to output contents into CSV

@Sigerson,
My apologies for the long overdue response. I lost track of this thread.
The type of "proxy" that I was talking about isn't like the fact that multiple people login...
--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 1, 2013 at 7:57 am

#1620284
RE: Can this be sorted without temporary tables

sku370870 (5/31/2013)
Jeff Moden (5/31/2013)
I guess the next question would be, why did you put leaders and followers in separate tables? It's a lot easier to manage such things if...
--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 1, 2013 at 7:21 am

#1620279

Viewing 15 posts - 26,731 through 26,745 (of 59,099 total)