Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,901 through 21,915 (of 59,072 total)

RE: How to Store the Image located in Another system into Local Database

Does the login for SQL Server have privs to see that other machine? And I'm not sure that an HTTP address will actually work with OpenRowset. A UNC...
--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 8:20 am

#1769525
RE: disk space used fully

Simple Recovery? Are you taking any backups?
Also, is the C: Drive on a SAN or is it on a disk in the server itself?
--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 8:18 am

#1769524
RE: How to model a slowly changing dimension

pietlinden (11/29/2014)
I am wondering how to model a slowly changing dimension. It's a basic sales database, pretty much like Contoso or the AdventureWorksDW databases. The part I'm not...
--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 8:16 am

#1769522
RE: Help me to tune this query in a better way

In that case, I wouldn't allow the "no values to any parameters" scenario.
--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:53 am

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

Viewing 15 posts - 21,901 through 21,915 (of 59,072 total)