Viewing 15 posts - 42,151 through 42,165 (of 49,552 total)
ps (12/23/2008)
create trigger trg_MyTrigger on myTableAfter Insert
AS
Declare @cardType as varchar(100)
Declare @devid-2 as varchar(100)
select @cardType=column1, @devid-2=column2 from inserted
exec HeadCountDetail @cardType, @devid-2
What's going to happen there if 3 rows are inserted...
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
December 23, 2008 at 4:57 am
santosh.lamane (12/23/2008)
FOR EACH ROW BEGIN
IF(NEW. coulmn1>2 AND NEW. coulmn1 < 4 ) begin
...
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
December 23, 2008 at 4:55 am
sayfrend (12/22/2008)
Ninja.People who ask question here in this forum are not as intelligent as you... please spare others.
Intelligence isn't in question here. Laziness is.
"I'm too lazy to read the...
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
December 23, 2008 at 4:49 am
CREATE PROCEDURE < Procedure Name >
AS
< Put query here >
Look up CREATE PROCEDURE in Books Online.
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
December 23, 2008 at 4:46 am
sashikanta.mishra (12/23/2008)
But in Oracle there is a table which traces last 1000 queries fired on the same database.
That's Oracle.
Can i get any kind of info from .LDF files
You can...
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
December 23, 2008 at 4:43 am
Bilichi (12/22/2008)
Replication is configured in Production only and not in my Development server.
Since that's a backup of a database that's replicated, there's replication set up in it as well. Create...
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
December 23, 2008 at 1:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic624449-5-1.aspx
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
December 23, 2008 at 1:05 am
jmohan_it (12/23/2008)
Any one can tell. what ia a breakpoint in ssis? How is it setup? How do you disable?
Have you looked through Books Online, specifically the sections on SSIS?
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
December 23, 2008 at 1:03 am
Not without a trace running. (profiler/server-side)
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
December 23, 2008 at 1:02 am
Someone's enable the query governor on the database, and set the threshold for 300. Speak to the DBA who looks after that server.
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
December 23, 2008 at 1:01 am
leonp (12/22/2008)
I meant to say I am seeing a lot of sessions with a 100% writer thread stats for this DB
Doesn't mean you have IO bottlenecks on the database server....
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
December 23, 2008 at 12:54 am
Pavas Malviya (12/22/2008)
Thank you for all the information...I think I need to use the extended proc
How's your C++ skills?
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
December 23, 2008 at 12:44 am
ramadesai108 (12/22/2008)
I still have a cursor
Why?
See my edited post above.
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
December 22, 2008 at 3:02 pm
ramadesai108 (12/22/2008)
Isn't it easier to use the 2 inserts based on the cursor values rather than doing a select as Gail pointed out?
Easier? Maybe. Slower? Definitely.
Also that update is running...
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
December 22, 2008 at 2:54 pm
leonp (12/22/2008)
Meanwhile, heres the question again, if these numbers look good, what is with the low PLE - 200.76?
Good question. The buffer cache hit ratio's high, so most pages SQL...
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
December 22, 2008 at 2:48 pm
Viewing 15 posts - 42,151 through 42,165 (of 49,552 total)