Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,306 through 22,320 (of 59,098 total)

RE: Sql 2012 server - Log Drive filled up by a runaway transaction - tips to investigate?

JustABob (12/2/2014)
D'oh, didn't think about checking dmv for longest running queries. Except now its too late as the server has been restarted. (Restarts every day at 1am. 3rd...
--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 2, 2014 at 8:20 am

#1762096
RE: The Value of Code

Dave62 (12/2/2014)
Megistal (12/2/2014)
There is one more arrow and note needed at the very top of the blue line. "Asks geek for script" 😀
:-D:-D:-D:-D
--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 2, 2014 at 7:36 am

#1762072
RE: The Value of Code

Yet Another DBA (12/2/2014)
Jeff Moden (12/1/2014)
......The only thing that really changes over time is the amount of data, the speed of throughput (thanks to tools available or built), and 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)

December 2, 2014 at 7:33 am

#1762068
RE: The Value of Code

From the article...
Now is the beginning of an era where we will have tremendous influence in helping change the way business works.
That's about the only thing in the that...
--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 1, 2014 at 11:33 pm

#1761942
RE: SQL Server service is not stopping

Knowledge Hunter (1/8/2013)
There was a bottleneck in a server.
What kind of bottleneck?
--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 1, 2014 at 10:54 pm

#1761939
RE: Need to get current DB Backup Set up list in PIVOT STYLE

poratips (12/1/2014)
I got it, Thanks.
;WIth mycte as (SELECT
s.database_name,
s.[type]
,row_number() Over(Partition by s.[type] Order by s.backup_finish_date DESC ) RN
FROM msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id)
Select database_name,...
--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 1, 2014 at 10:46 pm

#1761938
RE: Need to get 1st day of week from isowk

Not sure (didn't test the code) because you didn't provide any readily consumable data but I believe this should be pretty close to what you're looking for...
SELECT WeekNo...
--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 1, 2014 at 10:23 pm

#1761936
RE: 42% of 100% taken in clustered index insert

Grant Fritchey (12/1/2014)
Just because it's not an incrementing number doesn't mean that it's not a good choice for the clustered index.
I have to admit that I'm taken aback by that...
--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 1, 2014 at 10:09 pm

#1761935
RE: OnPeak/OffPeak Calculation

Deries (12/1/2014)
Jeff,
Could you show me some sample sql statement to create like you mentioned above.
The table structure which I gave stores the meter data for each customers on an hourly...
--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 1, 2014 at 8:51 pm

#1761928
RE: Sql 2012 server - Log Drive filled up by a runaway transaction - tips to investigate?

Considering that today is the first day of a new month, perhaps some eager beaver was trying some new ad hoc query for month-end reporting and ended up with an...
--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 1, 2014 at 8:39 pm

#1761925
RE: OnPeak/OffPeak Calculation

P.S. Using a UNIQUEIDENTIFIER as the Clustered PK of a table is "Death by page splits" on steroids!. Also, using a "CustomerName" in that table is also pretty...
--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 1, 2014 at 8:28 pm

#1761921
RE: OnPeak/OffPeak Calculation

Deries (12/1/2014)
Sean,
I am sorry,i get .cvs file from the client on monthly basis and i manipulate that in excel and give them the report. Sorry again.
Excellent! Post the CREATE...
--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 1, 2014 at 8:20 pm

#1761920
RE: Need to get 1st day of week from isowk

Luis Cazares (12/1/2014)
I use the following formula to calculate the previous monday. Just change GETDATE() for any date you need to use.
DATEADD(WK, DATEDIFF(WK, 0, GETDATE() - 2), 0)
Oh, be careful...
--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 1, 2014 at 8:10 pm

#1761919
RE: Running total

GrassHopper (12/1/2014)
Anyone think they can improve on this query?
Almost no question. The key here is that your code now has two real tables in it. For my 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)

December 1, 2014 at 7:25 pm

#1761916
RE: Last 30 days aggregate query

OK, here we go. This will go back for 30 days (not including "today" because it's a partial day) and also report on the same time span for all...
--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 1, 2014 at 6:55 pm

#1761914

Viewing 15 posts - 22,306 through 22,320 (of 59,098 total)