Viewing 15 posts - 23,011 through 23,025 (of 49,552 total)
On SQL 2005, pretty much yes.
Otherwise, multiple stored procedures for the cases where the various parameters are passed or not, but that means 4 procedures.
On the security side, the solution...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 3:55 pm
Within the trigger...
DECLARE @Operation VARCHAR(10)
IF EXISTS (SELECT 1 FROM inserted) and NOT EXISTS (SELECT 1 FROM deleted)
SET @Operation = 'Insert'
IF EXISTS (SELECT 1 FROM inserted) and EXISTS (SELECT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 3:36 pm
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 3:33 pm
Lynn Pettis (10/6/2011)
Did some testing and it looks like you do want to ANDs in the NOT EXISTS statement.Okay, boolean logic doesn't always work as you think in T-SQL.
Boolean logic...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 1:55 pm
Lynn Pettis (10/6/2011)
GilaMonster (10/6/2011)
Lynn Pettis (10/6/2011)
Didn't GETDATE() use to (or still get) the same error?Yes, in SQL 2000.
Then the code Jack ran into my be a vestige left over when...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 1:39 pm
Lynn Pettis (10/6/2011)
Didn't GETDATE() use to (or still get) the same error?
Yes, in SQL 2000.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 1:25 pm
Lynn Pettis (10/6/2011)
Jack Corbett (10/6/2011)
create view SYSTEM_DATE_VIEW
as select...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 1:03 pm
Jack Corbett (10/6/2011)
create view SYSTEM_DATE_VIEW
as select getdate() SYSTEM_DATE
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 12:55 pm
Stefan Krzywicki (10/6/2011)
GilaMonster (10/6/2011)
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 12:07 pm
The index is dependant on the column no matter how much data is in the table. It's just a schema rule.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 12:05 pm
AER (10/6/2011)
This is a Live database. Is it not going to affect performance?
Of course it will, badly. Both in terms of the IO that it's doing and in terms of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 12:00 pm
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm getting older as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 11:58 am
Shrinks can take hours, especially if there are LOB columns or a slow IO subsystem. Be patient.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 10:41 am
That's IO-related. It means SQL's requesting a page from the data file the shrink is waiting for that page.
How long did you wait before deciding the shrink was 'hung'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 10:34 am
No, query sys.dm_exec_requests and look at the wait_* columns.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2011 at 9:34 am
Viewing 15 posts - 23,011 through 23,025 (of 49,552 total)