Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,316 through 18,330 (of 59,070 total)

RE: Using Parameters in a Query is Killing Performance

It's really difficult to help by looking at the execution plan when the expected result set is zero rows. 😉
--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)

February 23, 2016 at 10:29 am

#1860495
RE: looping through a dim table

NewbieCoding (2/23/2016)
That worked great
Great. Thank you for the feedback.
Since you're the one that will need to support it, the next question would be... do you understand how and why...
--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)

February 23, 2016 at 10:21 am

#1860489
RE: Are the posted questions getting worse?

Phil Parkin (2/23/2016)
Any XML gurus out there who would like to help?
http://www.sqlservercentral.com/Forums/Topic1763386-3412-1.aspx
--Edit: fixed garbage English!
Heh... good grief. 1500 nodes. And it's not flat. It does contain a...
--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)

February 23, 2016 at 8:22 am

#1860427
RE: SLOW ETL only on weekends

sqllearner44 (2/23/2016)
Hi Jeff,
Is there a way i can notice things if they are turned down?
Regards,
SQLLearner
Yes... and it can be done from SQL Server if you're allowed to use xp_CmdShell. ...
--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)

February 23, 2016 at 8:01 am

#1860413
RE: SLOW ETL only on weekends

sqllearner44 (2/23/2016)
Hi Jeff,
From the DB end, I have confirmed i stop all the maintenance jobs just for this week to see if there is a better run. As in, 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)

February 23, 2016 at 7:59 am

#1860412
RE: Scrubbing Data - Good idea or bad idea?

MMartin1 (2/22/2016)
Are there industry standard documentation that specifically addresses the correct way to handle this?
The only one I know is that you must do requirements gathering from your team/client on...
--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)

February 22, 2016 at 11:32 pm

#1860280
RE: Count of Records in a Table by Military Time.

So others can follow along, here's some test data (10,000 rows) I made for a full month of entries across 10 different PatNo's.
SELECT TOP 10000
...
--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)

February 22, 2016 at 11:28 pm

#1860279
RE: Count of Records in a Table by Military Time.

In fact and judging from the columns you have in the CTE of your final query, I believe the following code can be used to replace the whole shebang (keeping...
--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)

February 22, 2016 at 9:59 pm

#1860271
RE: Count of Records in a Table by Military Time.

thomaswellington (2/22/2016)
Thanks for all the suggestions, everyone. The query below uses a case expression to get the time in am/pm format and then converts that to datetime. This...
--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)

February 22, 2016 at 9:28 pm

#1860266
RE: Are the posted questions getting worse?

Greg Edwards-268690 (2/22/2016)
Jeff Moden (2/22/2016)
No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how 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)

February 22, 2016 at 9:11 pm

#1860265
RE: looping through a dim table

First of all, welcome aboard.
Second, if you want to get test code for an answer, please see the article at the first link in my signature line below. You'll...
--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)

February 22, 2016 at 8:55 pm

#1860264
RE: Query timeout with linked server

ramana3327 (2/22/2016)
We have server A (Cluster) and Server B. Both of them are 2008r2
There are some jobs scheduled on server B which uses the server A databases using Linked server.
Some...
--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)

February 22, 2016 at 6:57 pm

#1860250
RE: How to query a Denormalised table

sushantkatte (2/22/2016)
@jeff Moden. Thank You very much for helping me to learn how to write queries. I still have to learn a lot and this gives me a little idea....
--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)

February 22, 2016 at 6:40 pm

#1860246
RE: SLOW ETL only on weekends

The weekends is typically when someone does the really heavy lifting such as making full backups at the machine level, running BeRemote to back up disk directories to tape, running...
--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)

February 22, 2016 at 5:37 pm

#1860241
RE: Identifying last backup and restoring to QA

ramana3327 (2/22/2016)
Hi,
We have Production server and backup job is running daily 9 pm for all dbs to the network path.
I have a requirement to restore daily one of the database...
--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)

February 22, 2016 at 5:20 pm

#1860239

Viewing 15 posts - 18,316 through 18,330 (of 59,070 total)