Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,271 through 6,285 (of 59,089 total)

Reply To: db size for all db's across servers from cms

I can't speak to the problem you're having with CMS (I don't use it) but it's a bit crazy having both of the columns in your table variable defined 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)

October 9, 2020 at 8:02 pm

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

Steve Jones - SSC Editor wrote:
For saving space, https://voiceofthedba.com/2014/12/01/creating-placeholder-files/
Those are handy to help trick the network folks into thinking that you're using more space than you are so you have time to make...
--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 6:20 pm

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

david.edwards 76768 wrote:
Grant Fritchey wrote:
Be careful of autogrowth here. Also, it's a good idea on any drive with auto-growth enabled, create an file called 'deletemeinemergencies' or similar. Make it big enough, say...
--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 6:18 pm

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

Viewing 15 posts - 6,271 through 6,285 (of 59,089 total)