Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 59,101 total)

Reply To: How to show multiple individuals>
Ken at work wrote:
```
Create Table #LeaveTable(Co int, Emp int, LeaveDate date);
Insert Into #LeaveTable (Co, Emp, LeaveDate)
Values
(1, 1001, '12/22/2020')
, (1, 1001, '12/23/2020')
, (1, 1001, '12/24/2020')
, (1, 1001, '12/28/2020')
, (1, 1001,...
```
--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)
October 9, 2020 at 3:59 pm

#3795515
Reply To: Stairway to Advanced T-SQL Level 10: Using Scalar Functions

I've not read this entire article but there does seem to be a problem... for example, this is a quote from the article...
When I ran the code in Listing 6,...
--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)

October 9, 2020 at 1:39 pm

#3795484
Reply To: Log space 98% free but drive has no space

dopydb wrote:
hi folks
just after some advice
if the Log space has 98% reported free space but the physical drive has virtually no free space left
will trans logs for the db post...
--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)

October 9, 2020 at 1:28 pm

#3795482
Reply To: What's the Lunch Factor?

For those complaining about review boards... despite the pain they seem to bring, I found that such "heavy handed" review boards are a thousand times better than having a "cowboy"...
--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)

October 9, 2020 at 1:18 pm

#3795480
Reply To: What's the Lunch Factor?

From the Article:
...Microsoft does, as do lots of organizations trying to embrace DevOps and produce higher quality...
Ok... you caused me to blow a pork chop bone out of 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)

October 9, 2020 at 2:34 am

#3794325
Reply To: Sudden PLE drop

VastSQL wrote:
Grant Fritchey wrote:
And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope. No...
--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)

October 8, 2020 at 7:57 pm

#3794199
Reply To: Log File Growing

PebbleRock978 wrote:
Hi,
We have a database that has 50GB of data, 99% of which is in one table. In this table there are 31,004,447 records, the developer is running a query...
--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)

October 8, 2020 at 4:46 pm

#3794142
Reply To: Query
If the format is guaranteed an you only want the first element, then the code can be greatly simplified.
```
 SELECT Result = SUBSTRING(SomeText,4,CHARINDEX('&',SomeText,4)-4)
   FROM #Stuff
...
```
--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)
October 7, 2020 at 6:04 pm

#3793753
Reply To: Execution Plan

Admingod wrote:
Thanks guys! We noticed this issue again. So this time I did not restart the database server at all and instead advised to restart application servers only and everything...
--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)

October 7, 2020 at 4:45 pm

#3793717
Reply To: Execution Plan

Admingod wrote:
How about query time-out to exit the query when it has been executed over default 10 minutes to unlimited 0?
If you have a front end query that's taking longer...
--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)

October 7, 2020 at 4:37 pm

#3793715
Reply To: Read Committed Snapshot Isolation and Blocking

Johan Bijnens wrote:
Are you sure your data system really needs it all in actual columns? ( advocate of the devil, I know )
Have you considered putting those "free wheeling columns" into...
--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)

October 7, 2020 at 3:54 pm

#3793693
Reply To: Profiler and Tuning Advisor Stats Recommendation

Even though I'm a fan of SQL Profiler, I don't use it to find queries that may be an issue. I've also found that "long running queries" are not usually...
--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)

October 7, 2020 at 1:32 pm

#3793629
Reply To: Profiler and Tuning Advisor Stats Recommendation

Grant Fritchey wrote:
... but take everything it recommends with a grain of salt the size of a Buick.
BWAAAA-HAAAA-HAAAAA!!!! Man, am I ever glad I didn't have a mouthful of coffee when...
--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)

October 6, 2020 at 5:33 pm

#3793324
Reply To: Nolock hint

DesNorton wrote:
Using NOLOCK is the SQL version of Russian Roulette.
Heh... with 5 of 6 chambers loaded and the really bad part is that you won't know that your report has...
--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)

October 6, 2020 at 5:11 pm

#3793295
Reply To: Are the posted questions getting worse?

Neil Burton wrote:
Well this is awkward.
Wow. Just 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)

October 6, 2020 at 3:45 pm

#3793266

Viewing 15 posts - 6,286 through 6,300 (of 59,101 total)