Viewing 15 posts - 47,911 through 47,925 (of 49,552 total)
select * from sys.procedures where modify_date > @Date
select * from sys.triggers where modify_date > @date
Or, if you want to check all objects
select * from sys.objects where modify_date > @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
December 28, 2007 at 8:11 am
p.s. Please post questions related to SQL 2005 in one of the SQL 2005 forums. Questions in the wrong place may get you inaccurate answers as we're assuming a different...
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 28, 2007 at 8:08 am
If you rebuild the index, you don't need to update the statistics. It's done as part of the index rebuild.
The ? is a place holder for the table name.
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 28, 2007 at 8:06 am
x-portal (12/28/2007)
Getting this error on the error log. Could someone help me to fix it?<snip>
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Budget'. [SQLSTATE 01000]
What error?...
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 28, 2007 at 8:05 am
mobasha (12/28/2007)
three hours?its along time, then it must be alot of questions.
is it more than 50 question or what.
Don't remember. I wasn't counting.
They do give you a fair amount...
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 28, 2007 at 7:59 am
Rather don't use the index tuning wizard. It's prone to giving rather sub-optimal suggestions. Learning to tune indexes yourself will get you much better results most of the time.
If you're...
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 28, 2007 at 6:13 am
Narendra (12/28/2007)
SELECT * from sys.procedures where modify_date >'12/20/2007'
sys.procedures doesn't exist in SQL 2000, and SQL 2000 doesn't have a modification date in sysobjects.
Both those are 2005 and higher features.
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 28, 2007 at 1:52 am
Try enclosing the DB name in square brackets
dump transaction [Rose-25-APR07] with no_log
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 28, 2007 at 12:25 am
Madhivanan (12/28/2007)
You need to use IS NULL or IS NOT NULL to check againt NULL
Yes. My point exactly. Do you know why?
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 28, 2007 at 12:17 am
What's the compatability mode of the databases i works in and the ones it doesn't?
Dump transaction is deprecated in SQL 2005. You should use Backup Log with truncate_only, or, even...
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:54 pm
Any form of function on a column in the where clause prevents index seeks, even something like UPPER, LEFT or the 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 12:44 pm
Please don't cross post. It fragments replies, wastes people's time and upsets the regulars
We read all forums
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:42 pm
Lowell (12/27/2007)
here's an example SQL: note that the function object_name takes a second paramter, dbid, only in SQL 2005.
2005 SP2 and higher.
If you are using SQL 2005, rather use 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:28 pm
Just note that this method will almost certainly prevent index seeks from been used to find affected records. It'll work, but it ain't likely to work fast.
It won't be noticeable...
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 11:02 am
Dunno. I'm going to do a bit of testing tomorrow, see if I can dig up any differences in how the queries run.
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:46 am
Viewing 15 posts - 47,911 through 47,925 (of 49,552 total)