Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,426 through 31,440 (of 59,101 total)

RE: Returning a column per date in a range

SQL Kiwi (1/11/2012)
drew.allen (1/11/2012)
I disagree.
No worries.
Granted, if this method was being used in production code you would have to consider the context to determine whether it was worth rewriting 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)

January 12, 2012 at 6:15 am

#1432405
RE: .ldf deleted and now cant attach database

It's a long shot and it doesn't always work but I've had some success in the past with such a thing.
1. Make sure the database in question...
--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)

January 12, 2012 at 5:02 am

#1432376
RE: databases file space utilization 100%?

MSQLDBA (1/10/2012)
Hi All,
Today i monitor my databases i found some of my databases are utilized 100% file space. What is the best solution to fix it,
1) Shrink db or
2) create...
--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)

January 11, 2012 at 5:17 pm

#1432224
RE: Censoring the Internet

Steve Jones - SSC Editor (1/10/2012)
I'd have to dig around, and it's hard to even know what the current version of the bill might change, but in one of 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)

January 10, 2012 at 4:37 pm

#1431496
RE: Understanding and Using APPLY (Part 1)

L' Eomot Inversé (1/10/2012)
Jeff Moden (1/9/2012)
As a side bar, you've got a huge amount of unnecessary code in your code example that you posted. Take the following snippet, 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)

January 10, 2012 at 4:31 pm

#1431493
RE: Dynamically create and populate staging tables from CSV files

Stan,
Nice step-by-step article with some timely graphics to show how to do things. Although it wasn't specifically named as such, I believe that folks will come to realize 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)

January 10, 2012 at 6:27 am

#1431066
RE: Dynamically create and populate staging tables from CSV files

surreydude. (1/10/2012)
A great little technique but I would probably only use this kind of thing for an initial Proof of Concept. Rarely would you want to (or be allowed 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)

January 10, 2012 at 6:16 am

#1431054
RE: Dynamically create and populate staging tables from CSV files

craig 81366 (1/10/2012)
The trouble then is that validation will only be performed when getting data from the staging tables to the destination tables.
I consider SQL, as a set based language...
--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)

January 10, 2012 at 5:55 am

#1431038
RE: Are the posted questions getting worse?

Revenant (1/9/2012)
Yes, it was Einstein who first used the dirty trick called "renormalization,"
Is that anything like repivoting an EAV back to 3rd normal form? 😛
--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)

January 9, 2012 at 11:22 pm

#1430906
RE: Censoring the Internet

Speaking of laws... I wonder why we need so many. Weren't the first 10 sufficient?
--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)

January 9, 2012 at 11:19 pm

#1430905
RE: Censoring the Internet

Revenant (1/9/2012)
Jeff Moden (1/9/2012)
Steve Jones - SSC Editor (1/9/2012)
It also allows for the bypass of a court order...
I don't believe that's true.... here's a quote from pages 13 and 14...
--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)

January 9, 2012 at 10:45 pm

#1430901
RE: Returning a column per date in a range

Agh! I totally misread the dates, Bob. Thank you for the correction. More coffee, please. :blush:
With that little revelation, it looks like Paul sussed the problem 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)

January 9, 2012 at 10:28 pm

#1430897
RE: Primary Keys are necessary for good database design

@cw.izatt ,
Did you actually check for an absence of FKs or just an absence of PKs? I ask because UNIQUE constraints will suffice for the instantiation of DRI. ...
--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)

January 9, 2012 at 10:26 pm

#1430896
RE: Global temp tables are not created through SQL TASK control.....

kramaswamy (1/9/2012)
Gonna have to agree with the others - just don't use the global temp table. Use a real table, and run a TRUNCATE TABLE at the start of your...
--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)

January 9, 2012 at 10:09 pm

#1430893
RE: Creating a round robin table with SQL & VB

I can create a Round Robin that shows the weekly schedule or just a schedule for a day in SQL and in a set based fashion. I just haven'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)

January 9, 2012 at 10:06 pm

#1430891

Viewing 15 posts - 31,426 through 31,440 (of 59,101 total)