Jeff Moden

Forum Replies Created

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

RE: bcp error

halifaxdal (10/21/2014)
I really like bcp but it really makes me frustrated, I keep getting error:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in...
--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 9:09 pm

#1753910
RE: Masking (Deidentification)

With the detail provided, my suggestion would be to replace non-null values with a GUID. You may have some difficulty with the postal code column if you have any...
--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:44 pm

#1753909
RE: When Work Gets in the Way of Work

Eric M Russell (10/21/2014)
Not only is there a high frequency of events, but there's also a number of new presentations to build. It seems I have 3-4 (at least) new...
--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:33 pm

#1753908
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

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