Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,931 through 21,945 (of 59,098 total)

RE: Is there a way to throttle or limit the amount of sql requests either by IP address or username?

TheSQLGuru (1/12/2015)
Jeff Moden (1/11/2015)
Or just make them run better. 😉 Then there won't be a problem that you have to throttle or manage.
Not true Jeff. You can absolutely...
--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)

January 12, 2015 at 7:48 am

#1769507
RE: Lists all databases, in an instance, that are not accessed before a given date

Jeff Moden (1/11/2015)
mesgetachew (1/10/2015)
Would appreciate if anyone knows a query that lists all databases, in an instance, that are not accessed before a given date (e.g., not accessed before December...
--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)

January 11, 2015 at 10:19 pm

#1769396
RE: Error messages

Reminds me of a question I once saw on a non-MS exam...
Which of the following Recovery Models will allow for minimally logged index rebuilds?
A. Bulk Logged
B. Bulk-Logged
C. Bulk_Logged
D. BulkLogged
😛
--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)

January 11, 2015 at 10:14 pm

#1769395
RE: update/insert

marybeth1975 (1/11/2015)
Hi I'm just trying to create a dataset that I can query against to perform calculation per month. Thank you!
Exactly why I don't understand the desired output you provided.
Anyway,...
--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)

January 11, 2015 at 9:41 pm

#1769392
RE: Assistance with an IF THEN in SQL Sever 2008 R2?

In that case and pretending this is your actual data...
SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY i_ticket_id ORDER BY dt_when)
,i_transaction_id
...
--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)

January 11, 2015 at 9:39 pm

#1769391
RE: Lists all databases, in an instance, that are not accessed before a given date

mesgetachew (1/10/2015)
Would appreciate if anyone knows a query that lists all databases, in an instance, that are not accessed before a given date (e.g., not accessed before December 31, 2014)?
BEFORE?...
--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)

January 11, 2015 at 9:34 pm

#1769390
RE: Screen layout messed up in Forum control panel

Steve Jones - SSC Editor (1/11/2015)
Is this still broken? It looks like you didn't pick up the CSS on the page. It's not a site problem overall, as this works...
--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)

January 11, 2015 at 9:28 pm

#1769388
RE: Missing Index DMVs suggest an existing index

nharris (1/11/2015)
Yes, Brent Ozar's resources are really handy - I do use them myself, but how is BlitzIndex going to identify missing indexes? It's going to use SQL Server's DMVs...
--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)

January 11, 2015 at 9:26 pm

#1769387
RE: Assistance with an IF THEN in SQL Sever 2008 R2?

chef423 (1/11/2015)
Jeff Moden (1/11/2015)
@chef423,
How do you want to handle 58475 when the following happens?
i_transaction_id c_amount dt_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)

January 11, 2015 at 9:24 pm

#1769386
RE: Assistance with an IF THEN in SQL Sever 2008 R2?

Yep... that's why I was willing to put up credits to Navy beans.:-D
See my previous post where I ask a question on what happens if...
--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)

January 11, 2015 at 9:22 pm

#1769385
RE: VERY SLOW PERFORMANCE OF SQL 2000 USING A VIRTUAL MACHINE

You need to get someone on site to help you. Index and stats maintenance needs to be checked and maybe implemented. If you don't have anyone that's SQL...
--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)

January 11, 2015 at 9:20 pm

#1769383
RE: "poor man's replication" ETL process design

I can't speak for Kevin but I roll my own, as well. Two different types but both use carefully created, hardcoded triggers. Notice that I didn't say "hand...
--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)

January 11, 2015 at 9:06 pm

#1769380
RE: Database Restore Hangs

Just remember that Instant File Initialization doesn't do squat for log files.
--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)

January 11, 2015 at 8:55 pm

#1769379
RE: Tempdb Shrink takes long time.

TheSQLGuru (1/11/2015)
Why in the world are you worried about 10GB on a 170GB file?!? Leave it and move on - I GUARANTEE you that you have MANY more things...
--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)

January 11, 2015 at 8:53 pm

#1769378
RE: SAN Response Times

Lowell (1/11/2015)
don't be ridiculous. you can run it on production. it's doing what your server is already doing; in this case it creates a four gig file and tests how...
--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)

January 11, 2015 at 7:39 pm

#1769371

Viewing 15 posts - 21,931 through 21,945 (of 59,098 total)