Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,051 through 16,065 (of 59,101 total)

RE: Update had to be done in two steps, Why?

Edvard Korsbæk (12/8/2016)
Originally I had this query:
Original value for starttime is 1800001 (Clarion time figures based upon 1/100 of a sec since 00:00 +1)
Update dbo.timeaccountmovement set
DATO = Getdate() ...
--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 9:08 pm

#1919663
RE: Update had to be done in two steps, Why?

John Mitchell-245523 (12/8/2016)
Edvard
Yes. Can you imagine the confusion if it were any other way? You wouldn't know whether you were getting old values or new values!
John
No confusion at...
--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 9:03 pm

#1919662
RE: Bitwise & NULL

Sergiy (12/15/2016)
ScottPletcher (12/15/2016)
Pretty soon you'll see in queries "WHERE Status&8 >0".
I guess I don't see why that's so much worse than a non-bit comparison of "status = 8" or...
--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 8:57 pm

#1919661
RE: Index with leading BIT column

Sioban Krzywicki (12/21/2016)
I've seen articles that say you shouldn't make the leading column in your index a BIT column. There are, of course, other articles pointing out the eternal truth...
--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 8:30 pm

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

Viewing 15 posts - 16,051 through 16,065 (of 59,101 total)