Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,006 through 16,020 (of 59,067 total)

RE: Script to find which active transaction is using more space in tempdb

Beatrix Kiddo (12/22/2016)
If you have such restricted access it sounds as though you're not the DBA, so you can probably hand that task over to whoever is.
Heh... +1 million to...
--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 28, 2016 at 9:17 am

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

ScottPletcher (12/28/2016)
Then you encode the actual BankAccount value into a related int, as I stated above. That value initially could be gotten from an identity column in another table...
--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 28, 2016 at 9:05 am

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

AZJim (12/27/2016)
I have found the following SQL very handy to do pretty much the same thing -- check on the progress of a back up. You can substitute whatever...
--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 27, 2016 at 9:58 pm

#1919818
RE: Bitwise & NULL

Sioban Krzywicki (12/27/2016)
If you have an index on a bit column & do inserts, are the new rows placed randomly within the other rows with the same value (i.e. 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 27, 2016 at 7:11 pm

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

Thanks for the feedback, Edvard. I wanted to make sure that there wasn't a monster living under the bed on this one. As the famous comedian known 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 27, 2016 at 1:23 pm

#1919767
RE: Bitwise & NULL

ScottPletcher (12/27/2016)
Jeff Moden (12/26/2016)
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...
--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 27, 2016 at 1:20 pm

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

ScottPletcher (12/27/2016)
How do you query that table, and how does it join to other tables? If it's by BankAccount, then definitely cluster by BankAccount value. If you need...
--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 27, 2016 at 1:01 pm

#1919762
RE: How can I query it fast ?

Eric M Russell (12/27/2016)
I would import the records from the .csv file into a user table (not a temp table), and then create a primary key on DriverMD5 column. 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 27, 2016 at 9:18 am

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

halifaxdal (12/27/2016)
Jeff,
I am shocked when I woke up and saw you have such a long reply to my question, I think that's why I love this forum, thank you very...
--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 27, 2016 at 9:14 am

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

With the idea that UPDATE in SQL Server can do both variable and column assignments in the same statement and with the understanding that I've not tested this particular bit...
--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 11:28 pm

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

Edvard Korsbæk (12/18/2016)
Days (tinyint) is a field in timeaccountmovement, and is used for 'Over midnight'
IF Days = o, then starttime and endtime is the same day
if days = 1, then...
--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 10:32 pm

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

Viewing 15 posts - 16,006 through 16,020 (of 59,067 total)