Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,021 through 16,035 (of 59,067 total)

RE: Using Large Integer Or GUID Vs Using Small Integers For Primary Key

SQLUSERMAN (12/25/2016)
Hi all,
Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary key column be less efficient than using an ID column of type integer...
--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)

December 26, 2016 at 7:17 pm

#1919659
RE: Is there a matured solution to ETL excel data?

With the understanding that some of the human dialog is missing and once you've taken the first step above and you don't mind it not being quite as detailed as...
--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)

December 26, 2016 at 6:35 pm

#1919656
RE: Is there a matured solution to ETL excel data?

halifaxdal (12/26/2016)
It might be possible to enforce some requirement to your client, I bet your boss would ask you not to do so.
Fortunately, I have some good input with my...
--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)

December 26, 2016 at 5:52 pm

#1919655
RE: Extended Events for Tracking Backup and Restore Progress

Man that seems like a lot of work. Wouldn't it be easier to just watch the screen during a restore? If it's supposed to be an automated restore,...
--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)

December 26, 2016 at 3:31 pm

#1919650
RE: Upgrading from SQL Server 2008 R2 to SQL Server 2016

SJanki (12/23/2016)
Hi All ,
[moving my question from the wrong forum to here!]
We have all application databases in SQL Server 2008 R2 .
I am looking forward to upgrade the 2008 R2...
--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)

December 26, 2016 at 3:26 pm

#1919649
RE: 70-432 Exam

herrypotter090 (12/26/2016)
Dumpspdf have the real and accurate questions answers for all Microsoft exam which is Reviewed by our professionals. Go for this to get 100% in your Exam.Join us today...
--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)

December 26, 2016 at 3:11 pm

#1919648
RE: TSQL query help needed

Additionally, DELETEs are fully logged no matter which Recovery Model you may be using. Sure, the SIMPLE recovery model removes the information from the Transaction Log File once 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)

December 26, 2016 at 2:48 pm

#1919646
RE: Is there a matured solution to ETL excel data?

halifaxdal (12/26/2016)
Thanks, still very tedious, actually adding one step here because data is eventually to be imported into SQL (or NoSQL), right?
It'll be much less tedious to brow beat 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)

December 26, 2016 at 2:34 pm

#1919645
RE: How can I ren files appending datetime to files names and move them to ohter folder

You're already using xp_CmdShell. Search for the following DOS commands to take it to the next level.
REN
FORFILES
ROBOCOPY
Also, learn how to capture the OUTPUT of the xp_CmdShell call in 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)

December 26, 2016 at 2:24 pm

#1919644
RE: AlwaysOn Availability Group and FCI using CSV

Heh... I can't help because I don't do these types of things but I think the use of the abbreviation of "CSV" is hilarious. Only Microsoft would name something...
--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)

December 26, 2016 at 1:27 pm

#1919642
RE: Bulk Insert vs. BCP Utility

johnwalker10 (12/25/2016)
Bulk Insert can only insert and BCP can import and export.
Bulk Insert runs inside SQL Server and BCP runs outside
BCP Utility is more flexible than bulk insert -...
--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)

December 26, 2016 at 1:16 pm

#1919641
RE: SQL 2012: how to parse a text datatype column into many different columns

elulu (12/24/2016)
You spoke my heart out!
And yet, there's no action you're going to take against it, eh?
--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)

December 24, 2016 at 10:15 pm

#1919604
RE: Today's Random Word!

TomThomson (12/24/2016)
whereisSQL? (12/23/2016)
DamianC (12/23/2016)
Manic Star (12/23/2016)
Revenant (12/23/2016)
djj (12/23/2016)
Ed Wagner (12/23/2016)
Grumpy DBA (12/23/2016)
Ed Wagner (12/23/2016)
Whisperer
Dog
Bark
Tree
Life
Circle
pi
Geometry
Euclid
Lucid
--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)

December 24, 2016 at 9:01 pm

#1919601
RE: Help with XML Splitter De-entitization, please.

@Mikael,
Perhaps I'm doing something wrong but the mTVF version doesn't return elements that result in empty strings..
[font="Arial Black"]Setup:[/font]
--===== Conditionally drop the test table to make reruns easier.
...
--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)

December 24, 2016 at 6:30 pm

#1919600
RE: How to improve performance, when using LIKE (or any other alternative?)

BOR15K (12/5/2016)
Thank you. Yet I will need to seek a permission from DBA's to add a new column across all the environments.
Write a script to do it and submit 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)

December 24, 2016 at 5:11 pm

#1919599

Viewing 15 posts - 16,021 through 16,035 (of 59,067 total)