Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,361 through 18,375 (of 59,102 total)

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
RE: Find the stored procedure name or Table name in entire SQL Server

Sree Divya (2/22/2016)
Hey,
i need to search one stored procedure is located under which database .
please any one help me giving the script.
Write a loop to step through the results of...
--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:10 pm

#1860237
RE: Help with performance (triggers)

sergio.arv (2/22/2016)
Hi,
Actually i have a huge Production DB with different machines identified by an id (Machineid), so , now i need to monitor each machine (last write data timestamp), my...
--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:06 pm

#1860236
RE: Are the posted questions getting worse?

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 get the current date...
--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 4:59 pm

#1860235
RE: Need script for number of times a job has failed in a week

naga.rohitkumar (2/21/2016)
Hi jeff ,
I have checked that msdb.dbo.sysjobhistory but its not giving the job name not status of the job when it failed
we need the count for number...
--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 4:54 pm

#1860234
RE: Need script for number of times a job has failed in a week

Recommend you take a look at the msdb.dbo.sysjobhistory table. Follow your nose from there. You can do 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 21, 2016 at 11:20 pm

#1860010
RE: thinking about Procedure vs trigger

tony28 (2/18/2016)
Hello, what do you think ,,, any suggestions ?
I will have app which will need data from tracking table about 30/40rows ( this table is update an selected lot...
--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 21, 2016 at 9:17 pm

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

TeraByteMe (2/21/2016)
Wondering what the pitfalls or benefits are for developing scrubbing data within the development of a report?
Is this a good idea or should it be handled in other ways...
--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 21, 2016 at 8:01 pm

#1860005
RE: Study Guide(70-461 Querying MS SQL)

fritzjoery (2/21/2016)
Hi guys, i just want to know if there are study group that currently studying T-SQL together.
I want to take 70-461 Querying MS SQL in the few months.
I already...
--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 21, 2016 at 2:00 pm

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

thomaswellington (2/21/2016)
I wrote the query below to get the number of episodes of restraint each hour. I wanted the hour to show up in AM/PM format. The time...
--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 21, 2016 at 1:50 pm

#1859996
RE: Debug sql server queries without any windows user

ebrahim_520 (2/20/2016)
I need your help for debugging.
I Want to allow my SQL Server logins to debug while windows login is disable or haven't SysAdmin Role.
When I disable Windows Login, I...
--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 20, 2016 at 11:22 pm

#1859978
RE: Datediff with NULL date

VG-619426 (2/20/2016)
HOw to get Datediff (dd, date1, date2) ? date1 comes from a table and date2 drrived in he query with a case statement. date2 is sometimes NULL.
I derrive date2...
--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 20, 2016 at 11:14 pm

#1859977
RE: Using Parameters in a Query is Killing Performance

Loner (2/19/2016)
Here is the actual execution plan with option recompile.
Thanks
Something is a little crazy with the second query. It's returning 0 rows. Is that intentional?
--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 20, 2016 at 3:13 pm

#1859974
RE: How to query a Denormalised table

sushantkatte (2/20/2016)
@
Jeff Moden. this is not the actual table that was given to me. i was given the question in this form and was asked to write queries looking at...
--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 20, 2016 at 2:51 pm

#1859972

Viewing 15 posts - 18,361 through 18,375 (of 59,102 total)