Viewing 15 posts - 47,926 through 47,940 (of 49,552 total)
Back on SQL 2000 I had a job that would run a checksum or checksum aggregate over some columns of the system tables to look for changes. Wasn't pretty, but...
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 27, 2007 at 10:29 am
It has to roll back. It's a property of transactions that they complete totally or not at all. since this one's been cancelled, it must undo all that it's done....
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 27, 2007 at 10:27 am
Ah. I took it to be something else (website or other app where the DB defines and controls the Gui)
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 27, 2007 at 5:43 am
Or in a very high volume OLTP, where lots and lots of small queries are run ver frequently.
Is just conjecture until tested though.
If it is the case, then is...
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 27, 2007 at 5:26 am
Other than protecting against future changes, I can't think of a good reason.
Possibly SELECT * requires an extra lookup to the system tables to get the column names. Kinda like...
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 27, 2007 at 4:49 am
What?
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 27, 2007 at 12:32 am
SELECT name from sys.procedures where modify_date > @MyDate
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 27, 2007 at 12:30 am
In SQL 2005 you can look at the modify_date in sys.tables
In SQL 2000 I don't think there's any way of checking, unless you've got a trace 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 27, 2007 at 12:27 am
About 3 hours, if I recall, and the number of questions varies. You get a timer at the top of the screen.
Work carefully and steadily. If you know 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 27, 2007 at 12:20 am
A rollback statement will rollback all open transactions on that connection. There's no need to keep track of transaction names and, in fact, naming transactions in SQL is more for...
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 27, 2007 at 12:14 am
SQL 2000 questions are best posted in the SQL 2000 forums.
Do you mean last change of structure or last change of data?
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 26, 2007 at 11:51 pm
namtaru (12/26/2007)
Select *From dbo.customers
Would that plan be cached? and be reusable?
Yes and yes. It's a simple plan and there;'s no reason for it not to be cached and reused....
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 26, 2007 at 11:48 pm
paul holroyd (12/24/2007)
I am using a CLR instead of T-SQL in order to evaluate new features available with sql server 2005. CLR's appear to enable all code...
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 26, 2007 at 11:17 pm
I'd prefer to rewrite the procedure so that it can handle a set-based solution. Since the proc's only ever called from the trigger, that shouldn't be hard, if the OP...
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 26, 2007 at 10:53 pm
OK, then it's most likely because the server's collation differs from the databases, or the database has tables in it with different collations.
Check the collation of the DB that...
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 24, 2007 at 3:15 am
Viewing 15 posts - 47,926 through 47,940 (of 49,552 total)