Viewing 15 posts - 12,091 through 12,105 (of 19,560 total)
I find that extremely odd. Can we get the DDL for this table? Including the indexes?
And we are 100% certain that there are no forwarded records?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 12:30 pm
Yes, and I should have clearly stated that you made me think of a trigger for the table.
A trigger at the DB level or the Server level would be too...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 12:29 pm
Thanks - nice question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 12:18 pm
Brandie Tarvin (9/28/2010)
You can use them to rollback transactions (in this case for INSERT statements). The only caveat is that I can't remember...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 12:14 pm
mechanic - again
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 10:38 am
Alvin Ramard (9/28/2010)
Jeff Moden (9/28/2010)
It's disappointing, for sure but... you still got paid and they didn't blame you so probably not such a bad gig, eh?
Jeff, you trying to speak...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 9:33 am
Gianluca Sartori (9/28/2010)
CirquedeSQLeil (9/27/2010)
Anybody here have much experience with FirebirdSQL?
Well, I wouldn't say "much experience", but I've had to deal with it in the past.
Is there anything particular you're looking...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 28, 2010 at 9:24 am
LutzM (9/27/2010)
CirquedeSQLeil (9/27/2010)
Even with an explicit deny on the table for update, delete, and insert as well as the denydatawriter - the user...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 6:01 pm
Makes sense to me - time to visit the Connect items.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:53 pm
Anybody here have much experience with FirebirdSQL?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:49 pm
Anybody here really good with permissions?
http://www.sqlservercentral.com/Forums/Topic994116-359-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:43 pm
Very interesting. I have learned something new.
Even with an explicit deny on the table for update, delete, and insert as well as the denydatawriter - the user that executes...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:41 pm
george sibbald (9/24/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:30 pm
In your procs, do you have a statement that has "Execute as" near the top?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:25 pm
David.Lavers (9/27/2010)
When executed on a local machine, why doesn't this stored procedure find itself running?
The script excludes itself from the result set.
where s.is_user_process=1 AND s.session_Id NOT IN (@@SPID)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 27, 2010 at 5:00 pm
Viewing 15 posts - 12,091 through 12,105 (of 19,560 total)