Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,561 through 16,575 (of 59,067 total)

RE: Importing - best approach to compare Excel row counts against the table created

Phil Parkin (10/20/2016)
Jeff Moden (10/20/2016)
Phil Parkin (10/20/2016)
Jeff Moden (10/20/2016)
Phil Parkin (10/20/2016)
First point to note is that a CSV file is a far far better thing to be importing from than...
--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, 2016 at 7:02 am

#1907943
RE: Dynamic rows into columns

Let's make this whole thing a bit more dynamic and let's make it so that we don't actually have to manually define a table with more than 50 columns 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 20, 2016 at 11:05 pm

#1907853
RE: Restarting SQL Server Instance from SSMS Error

When running remotely, you may have to start with the "Run as Administrator" for this to work.
--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, 2016 at 4:44 pm

#1907818
RE: Truly cleaning sensitive LOB data

SeanNerd (10/20/2016)
I'm working for a client that has some unencrypted sensitive data stored in XML blobs (like social security numbers). They have since fixed the problem in the application, 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)

October 20, 2016 at 4:20 pm

#1907813
RE: Recording data changes

Bruce-12445 (10/19/2016)
Hi Jeff
I'm trying to add a bit more info into the audit table by adding this:
SELECT client_net_address,local_net_address,host_name,original_login_name,login_name,program_name
FROM sys.dm_exec_connections SCON
OUTER APPLY sys.dm_exec_sessions SES
WHERE SCON.session_id = @@SPID
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)

October 20, 2016 at 4:08 pm

#1907810
RE: Looking for help on transpose the result to be improved with pivot

PasLe Choix (10/20/2016)
I fixed it, thank you very much.
Can you explain how to do this using the PIVOT function?
It will be slower, in most cases.
--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, 2016 at 3:58 pm

#1907808
RE: sql backup

patrickmcginnis59 10839 (10/20/2016)
Brandie Tarvin (10/20/2016)
Jeff Moden (10/19/2016)
Steve Jones - SSC Editor (10/19/2016)
Jeff Moden (10/18/2016)
Using compress backups and having a really good team that put together some remarkable hardware, I'm backing...
--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, 2016 at 3:08 pm

#1907801
RE: Importing - best approach to compare Excel row counts against the table created

Phil Parkin (10/20/2016)
Jeff Moden (10/20/2016)
Phil Parkin (10/20/2016)
First point to note is that a CSV file is a far far better thing to be importing from than an Excel file.
"It...
--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, 2016 at 10:37 am

#1907718
RE: One Million

I have a demo I gave in a recent precon (first precon... YAY!) that processed all 7 million rows (each row was about 1040 bytes wide) in a table 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 20, 2016 at 8:14 am

#1907673
RE: Parameter on Powershell Script

Luis Cazares (10/20/2016)
Oh Magoo, you've done it again! 😀
Heh... glad I'm not the only one that says 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)

October 20, 2016 at 8:01 am

#1907662
RE: Importing - best approach to compare Excel row counts against the table created

Phil Parkin (10/20/2016)
First point to note is that a CSV file is a far far better thing to be importing from than an Excel file.
"It Depends". If someone...
--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, 2016 at 7:54 am

#1907658
RE: sql backup

Brandie Tarvin (10/20/2016)
Jeff Moden (10/19/2016)
Steve Jones - SSC Editor (10/19/2016)
Jeff Moden (10/18/2016)
Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.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)

October 20, 2016 at 7:26 am

#1907643
RE: sql backup

Steve Jones - SSC Editor (10/19/2016)
Jeff Moden (10/18/2016)
Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to Network Attached...
--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, 2016 at 5:52 pm

#1907557
RE: Archaic Commands

chrisn-585491 (10/19/2016)
I personally don't like complex tasks that require many steps in GUI application. [font="Arial Black"]It's probably why I don't care for much of SSIS quirks.[/font] Or the fact 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)

October 19, 2016 at 8:25 am

#1907426
RE: Deleted

Eric M Russell (10/19/2016)
Jeff Moden (10/18/2016)
Just to throw my opinion into the ring...
I've been tremendously successful and I barely know how to spell SSIS, SSDT, SSAS, SSRS, or any 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)

October 19, 2016 at 8:02 am

#1907422

Viewing 15 posts - 16,561 through 16,575 (of 59,067 total)