Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,656 through 8,670 (of 59,099 total)

Reply To: Query Help Pivot

The question now is... do you understand how and why it works? Also, for future reference, this ancient but incredibly effective method is known as a "CROSSTAB". It used 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)

September 17, 2019 at 4:31 pm

#3680769
Reply To: Time and Space: How to Monitor Drive Space in SQL Server

bonagiris9 wrote:
I recently implemented this procedure in our test environment, and I don't see any data in Drivespace. Not sure why it is not populating the data in Drive space...
--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)

September 17, 2019 at 4:26 pm

#3680766
Reply To: Table Rows deleted but not shrinking in size

p.s. I also verified that the Compatibility Level for the database is SQL Server 2016.
For those interested, the 3rd party database is "WhatsUp" and was created by the "WhatsUp Gold"...
--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)

September 17, 2019 at 2:41 pm

#3680728
Reply To: Table Rows deleted but not shrinking in size

Hmmm... interesting. I just found out that a 3rd party database on my system has this problem and the tables are NOT heaps. Multiple Clustered and Non-Clustered indexes have 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)

September 17, 2019 at 2:30 pm

#3680721
Reply To: SQL Server Restore precheck gets free space wrong

BobAtDBS wrote:
Good question, and I wondered the same thing. I took the defaults when I built the volumes on the S2D Pool. This query shows that the block size is...
--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)

September 16, 2019 at 7:30 pm

#3680469
Reply To: CREATE INDEX query in sys.dm_exec_requests

webrunner wrote:
I noticed that the a.text/Query column contains: insert [dbo].[Table] select * from [dbo].[Table]
Why is that? Does the index creation literally re-insert every row in the table into itself?
The answer...
--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)

September 16, 2019 at 7:17 pm

#3680467
Reply To: running sum cursor

Unfortunately and based on the name of this particular forum, it looks like the OP is still using SQL Server 2005.
--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)

September 16, 2019 at 1:31 pm

#3680321
Reply To: Logical reads and its size

Yep... agreed. You weren't asking for one. That's why I made the comments I did.
--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)

September 15, 2019 at 6:39 pm

#3680146
Reply To: Query TSQL

I'll also state that if you have the UNIQUE index you say you do as...
-- PK or unique key is combined key(custid,procustid,team_id)
... we'd not be able to build the sample...
--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)

September 15, 2019 at 6:37 pm

#3680145
Reply To: Staying Focused

I work best in an environment that has a constant background noise like a 20" box fan (good source of the right tone of "pink" noise for me) to drown...
--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)

September 15, 2019 at 3:59 pm

#3680136
Reply To: Logical reads and its size

frederico_fonseca wrote:
He can supply it - just needs to use SQL Sentry Plan explorer to anonymize it before posting here.
The thing is... he doesn't actually need to supply it because...
--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)

September 15, 2019 at 2:26 am

#3680112
Reply To: Logical reads and its size

jignesh209 wrote:
I agree that the procedure need to be fixed but coming to terms with 120 TB being processed is very perflxing(how a RAM of 196 GB is processing 120...
--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)

September 15, 2019 at 2:14 am

#3680111
Reply To: CREATE INDEX query in sys.dm_exec_requests

Is the index in question a "Clustered Index"?
--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)

September 14, 2019 at 10:02 pm

#3680104
Reply To: Table Rows deleted but not shrinking in size

briancarr wrote:
Hi, the tables are updated using SSIS package basically what happens is an sql command runs (delete from table) then a connection to an external odbc dbase (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)

September 12, 2019 at 1:32 pm

#3679510
Reply To: Table Rows deleted but not shrinking in size

briancarr wrote:
Hi Folks, a general question here for better admin on a database. Have a number of tables, with approx 100 rows that clear down and re-populate every 5 minutes,...
--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)

September 12, 2019 at 12:54 pm

#3679477

Viewing 15 posts - 8,656 through 8,670 (of 59,099 total)