Thanks for article Roy.

i am considering turning on these features on an application we have at my current company, but had a question.

If i alter my database with;

ALTER DATABASE MyDatabase

SET...

declare @MyTable table (CardType varchar(50), Completed bit)

insert into @MyTable

VALUES

('ATM_Issue.CRD', 1),

('ATM_RePIN.CRD' ,0),

('Debit_Business_Issue.CRD', 0),

('Debit_Business_RePIN.CRD', 1),

('ATM_Issue.CRD', 1),

('ATM_RePIN.CRD' ,0),

('Debit_Business_Issue.CRD', 1),

('Debit_Business_RePIN.CRD', 0),

('ATM_Issue.CRD', 1),

('ATM_RePIN.CRD' ,0),

('Debit_Business_Issue.CRD', 0),

('Debit_Business_RePIN.CRD', 1),

('ATM_Issue.CRD', 1),

('ATM_RePIN.CRD' ,0),

('Debit_Business_Issue.CRD', 1),

('Debit_Business_RePIN.CRD', 0),

('ATM_Issue.CRD', 0),

('ATM_RePIN.CRD' ,1),

('Debit_Business_Issue.CRD', 1),

('Debit_Business_RePIN.CRD', 0),

('ATM_Issue.CRD',...

GilaMonster (1/23/2012)

---

If there's only ever 1 or 0 matching rows, kinda yes.

If there could be more, then no, not performance...

SQL Kiwi (1/23/2012)

---

The idea behind the requirement worries me - what are you looking to do with the result? Anyway, this is one reasonably efficient way to do what...

GilaMonster (1/23/2012)

---

CREATE PROCEDURE [dbo].[sp_GGA_Testing_3] @status INT, @ID INT

AS

IF EXISTS (SELECT 1

...

Great article Wayne. This is great info to have when management wants to know why we are always upgrading 😀

With cteObjectTypes AS

(

SELECT

...

http://technet.microsoft.com/en-us/library/dd255278.aspx">

http://technet.microsoft.com/en-us/library/dd255278.aspx

based on what you said, you must be shrinking the log file too. you should stop that if you are.

auto grow will grow as needed that is true, but it...

you can't. by default the page size is 8.5 x 11 and the report will fit onto that (or many pages) if needed.

you can of course, change the size to...

ok, try this one. I used your same tmp tables and logic, i only changed your cte into a table variable for the update and changed the join to compare...

disregard my previous post. I see what you are after now... I will get back to you.

your explanation is a bit unclear as why you want NULLs. can't you just eliminate the possibility of generating NULL's??

if object_id('tempdb.dbo.#Calendar') > 0 drop table #Calendar

create table #Calendar(Exchange...

Agreed Gail, but without firing up SQL Profiler, it is sometimes a good start.

seems the poster just needs a push to start looking somewhere.

you could start by looking at your 10 worst performing queries;

SELECT DISTINCT TOP 10

t.TEXT QueryName,

s.execution_count AS ExecutionCount,

s.max_elapsed_time AS MaxElapsedTime,

ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0), 0) AS AvgElapsedTime,

s.creation_time AS LogCreatedOn,

ISNULL(s.execution_count /...