Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,576 through 7,590 (of 59,098 total)

Reply To: Generate Index only Script for Whole db

Admingod wrote:
Simple recovery model. Approx 15 million rows. Unless bulk-logged is faster than simple?
Simple and Bulk Logged are the same for this type of thing. You didn't answer the rest...
--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)

March 14, 2020 at 12:00 am

#3734352
Reply To: Generate Index only Script for Whole db

Admingod wrote:
Thanks! I ran some tests first with clustered index in-place and second with clustered index dropped, load the data and add the clustered index back . Noticed second one...
--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)

March 13, 2020 at 11:16 pm

#3734339
Reply To: Details of the transactions in Sql Server 2008 R2.

Grant Fritchey wrote:
Jeff Moden wrote:
Heh... Hi! My name is Jeff. Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀
HA!
And why you want to?
I'll give you 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)

March 13, 2020 at 10:28 pm

#3734330
Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

Thom A wrote:
Jeff Moden wrote:
Aye. And I'd also like to see them fix the actual code for the ordinal. All they need to do is change one bloody word in the code...
--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)

March 13, 2020 at 3:12 pm

#3734092
Reply To: Details of the transactions in Sql Server 2008 R2.

Heh... Hi! My name is Jeff. Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀
--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)

March 13, 2020 at 3:11 pm

#3734090
Reply To: Cursor inside a Stored procedure

Hold the phone a minute... if this worked on a different instance, you have to ask yourself what changed when you copied it to the new instance if it doesn't...
--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)

March 13, 2020 at 2:50 pm

#3734075
Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

Aye. And I'd also like to see them fix the actual code for the ordinal. All they need to do is change one bloody word in the code and update...
--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)

March 13, 2020 at 2:46 pm

#3734074
Reply To: top cqu sql how to tune

We're spinning our wheels because we don't know enough about your code or the underlying tables. You even have an error in the FROM clause of the code in your...
--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)

March 12, 2020 at 11:36 pm

#3733845
Reply To: Credibility of TABLE_SCHEMA column in INFORMATION_SCHEMA objects

I wonder if this is based a bit on old pre-2005 wives' tales that possibly used to be true and a bit on the 5 Monkeys Syndrome or maybe on...
--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)

March 12, 2020 at 11:08 pm

#3733838
Reply To: Query Tuning Question

coolchaitu wrote:
Is query tuning the responsibilty of a Developer or is it a combined responsibility of DBA and SQL Developer.
jonathan.crawford wrote:
You simply do your best. If you are not allowed...
--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)

March 12, 2020 at 10:55 pm

#3733835
Reply To: SQL patching solution and automation

Aren't those supposed to be backslashes instead of forward slashes? Could that be the remaining issue?

--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)

March 12, 2020 at 10:30 pm

#3733819
Reply To: Restoring file group from one database to another

You might want to look into partitioning. If I had it to do over again (I had a similar requirement), I'd have used a Partitioned VIEW instead of a Partitioned...
--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)

March 12, 2020 at 10:24 pm

#3733815
Reply To: The Triple Update
Magnus Ahlkvist wrote:
This is fun code to test and try to get ones head around - in which orders are operators applied.
```
DECLARE @i INT=0;
UPDATE t SET @i =...
```
--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)
March 12, 2020 at 9:54 pm

#3733804
Reply To: Gap Analysis Using Algebra

Ah... gotcha. Thanks, Glenn. I'll do my best over the weekend.
--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)

March 12, 2020 at 2:30 pm

#3733636
Reply To: Gap Analysis Using Algebra

Glen Cooper wrote:
A SQL Server solution to this problem, without using mathematics, would be very interesting. This was a real problem that I worked on, and I expected to do some...
--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)

March 12, 2020 at 4:41 am

#3733464

Viewing 15 posts - 7,576 through 7,590 (of 59,098 total)