Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,606 through 22,620 (of 59,099 total)

RE: Query logic help please

CELKO (10/21/2014)
You need to learn basic RDBMS. All of SQL is based on scalar values and 1NF. We never split strings in good SQL! That is done in the presentation...
--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)

October 21, 2014 at 3:14 pm

#1753887
RE: Temporal SQL Server Databases

sqlvogel (10/21/2014)
Jeff Moden (10/20/2014)
I guess I don't understand the problems people are having with temporal data. Type 2 SCDs are easy to setup, implement, and use. As 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)

October 21, 2014 at 2:49 pm

#1753885
RE: How to prevent email if report has no results

Jack Corbett (10/21/2014)
Jeff Moden (10/21/2014)
SQLRNNR (10/17/2014)
You can try data driven subscriptions.
Here is something to look at for that.
http://msdn.microsoft.com/en-us/library/ms159150(v=sql.90).aspx
+1000
If you have enterprise edition.
Ah... yeah... Don't you just love 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)

October 21, 2014 at 2:37 pm

#1753882
RE: How to prevent email if report has no results

SQLRNNR (10/17/2014)
You can try data driven subscriptions.
Here is something to look at for that.
http://msdn.microsoft.com/en-us/library/ms159150(v=sql.90).aspx
+1000
--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)

October 21, 2014 at 1:17 pm

#1753855
RE: Are the posted questions getting worse?

spaghettidba (10/21/2014)
Hi!
It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now 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)

October 21, 2014 at 8:27 am

#1753763
RE: Query logic help please

Eirikur Eiriksson (10/20/2014)
Some code refactoring on the previous set based solution to fulfil all the requirements, several orders of magnitude faster than string manipulation although it has not been tested...
--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)

October 21, 2014 at 12:13 am

#1753659
RE: Are the posted questions getting worse?

rodjkidd (10/16/2014)
Hey Grant, you do realise that your utili kilt just won't cut the mustard now on Kilt Day at the Summit. You need a proper one with you special...
--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)

October 20, 2014 at 10:51 am

#1753580
RE: Are the posted questions getting worse?

I'm a little late to the party but my most sincere congratulations to Grant for his new position on the PASS Board. Very well deserved.
--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)

October 20, 2014 at 10:49 am

#1753578
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/15/2014)
Luis Cazares (10/14/2014)
That sounds like a good and bad news. And the good news sound great.
Thank you for the update, Steve.
In an unrelated topic, have...
--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)

October 20, 2014 at 10:05 am

#1753559
RE: File Size from T-SQL

Gazareth (10/20/2014)
Yep, just use a UNC path - \\servername\... instead of the local path.
It's a bit more work to insert into a SQL table but thought you could do 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)

October 20, 2014 at 9:46 am

#1753545
RE: Temporal SQL Server Databases

Ian Massi (10/20/2014)
I've added effective dates to one of the fact tables in my data warehouse to allow reporting using different points in time. The application that generates 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)

October 20, 2014 at 8:53 am

#1753523
RE: Search Millions of Column Values in Another Column

I'd start by simply filtering out any "document" that doesn't have an "@" sign in it. That's bound to cut out some of the documents.
The next step would be...
--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)

October 19, 2014 at 8:49 pm

#1753385
RE: File Size from T-SQL

ralu_k_17 (10/17/2014)
Hi,
I need a way to get a physical file's size from T-SQL, without using xp_cmdshell.
My exact situation is this:
I need to query a folder (TB of data), with 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)

October 19, 2014 at 7:31 pm

#1753383
RE: Temporal SQL Server Databases

Randy AV (10/18/2014)
I am one of the authors of "Managing Time in Relational Databases" published by Morgan Kaufmann and reviewed by Joe Celko. While writing the book, we also...
--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)

October 19, 2014 at 1:55 pm

#1753376
RE: File Size from T-SQL

spaghettidba (10/19/2014)
Jeff Moden (10/17/2014)
Gazareth (10/17/2014)
spaghettidba (10/17/2014)
If this is an import project, SSIS might be what you're looking for
Seconded.
Heh... I like the OP's idea of doing this all from T-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)

October 19, 2014 at 1:51 pm

#1753375

Viewing 15 posts - 22,606 through 22,620 (of 59,099 total)