Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,331 through 18,345 (of 59,070 total)

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
RE: Are the posted questions getting worse?

SQLRNNR (2/19/2016)
Luis Cazares (2/19/2016)
TomThomson (2/19/2016)
Luis Cazares (2/19/2016)
Hugo Kornelis (2/19/2016)
Jeff Moden (2/19/2016)
In that same vein, I also won't work for a company that requires you to pass an "intelligence test" or...
--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 19, 2016 at 7:04 pm

#1859945
RE: Indexes are not visible

ramana3327 (2/19/2016)
Those are hypothetical indexes. Is it better to keep or drop those hypothetical index?
Google is your friend here...
https://www.google.com/?gws_rd=ssl#q=deleting+hypothetical+indexes+and+statistics
--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 19, 2016 at 6:44 pm

#1859944

Viewing 15 posts - 18,331 through 18,345 (of 59,070 total)