Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,426 through 10,440 (of 59,095 total)

RE: Restoring with multiple BAK-files (with multiple CPU-cores)

gkramer 23701 - Thursday, December 6, 2018 8:17 AM
Enterprise edition
In that case, if you're not using compression, you should give it 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 6, 2018 at 3:21 pm

#2015708
RE: blocking for same query on user DB

Let's stop guessing... what is the query? What is the actual execution plan. Please see the second link in my signature line below for what we need to be able...
--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 6, 2018 at 9:11 am

#2015683
RE: delete records in batches?? and recursive for tables

s.ravisankar - Thursday, December 6, 2018 8:12 AM
I have number of tables , I want to purge record based 3 month timeline.
eg:
select...
--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 6, 2018 at 8:38 am

#2015675
RE: Pivot multiple columns into one row

Uji2 - Thursday, December 6, 2018 8:29 AM
Is there a way to do this in one statement without writing dynamic sql?
Thanks...
--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 6, 2018 at 8:33 am

#2015671
RE: MoSQL

Heh.... to play a bit on the quote in my signature line (which is also a play on words)...
Them (whoever they are): "Yeah Jeff? Well, to a hammer,...
--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 6, 2018 at 8:25 am

#2015666
RE: Restoring with multiple BAK-files (with multiple CPU-cores)

Do you have the Standard or Enterprise edition of SQL Server?
Also, spitting the backups to multiple files could actually slow things down unless you can guarantee that each...
--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 6, 2018 at 8:14 am

#2015663
RE: Where clause on a bit column

tmmutsetse - Thursday, December 6, 2018 7:23 AM
Hi Experts,
I want results based on a where clause , all columns in the where...
--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 6, 2018 at 7:59 am

#2015662
RE: TempDB previous usage

I find that if it's actually to be found in the default trace, you got damned lucky. Most default traces get full and rollover very quickly on busy systems.
--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 6, 2018 at 7:51 am

#2015660
RE: Practical Uses for Synonyms in SQL Server

Alan G-436699 - Friday, July 1, 2016 1:44 PM
I've recently discovered a great use of synonyms. My company won't refresh UAT from...
--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 6, 2018 at 6:58 am

#2015650
RE: adding each row incremental

Ah... just can't do it... there are a few things wrong with that site including their statement of "you agree to license everything you submit by
--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 5, 2018 at 6:38 pm

#2015620

RE: Lack of clustered index generally a good idea?

Scott Coleman - Friday, November 30, 2018 2:42 PM
it is just too darn difficult to choose a good clustering key. As 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 5, 2018 at 6:26 pm

#2015619

RE: Import specific rows from Excel

Phil Parkin - Tuesday, December 4, 2018 5:24 PM
John524 - Tuesday, December 4, 2018 4:16 PM
--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 5, 2018 at 6:13 pm

#2015618

RE: Return data even if no record present

sindhupavani123 - Wednesday, December 5, 2018 4:35 AM
Hi all,
I have table called students, and I would get record even if data...
--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 5, 2018 at 9:56 am

#2015579

RE: Clustered Index Scan vs Seek

The real key (no pun intended) is that the method you're using to do such an increment is prone to problems. I strongly recommend that find a better way. For...
--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 5, 2018 at 9:53 am

#2015578

RE: Sql 2017/2019 unattended installs tempdb files

gksingh005 - Tuesday, December 4, 2018 9:55 PM
craig it seems this is the default behaviour of sql 2017/19 you need not worry.
Wow......
--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 5, 2018 at 9:50 am

#2015577

Viewing 15 posts - 10,426 through 10,440 (of 59,095 total)
Prev
1
2
3
…
695
696
697
…
3,938
3,939
3,940
Next