You can create a table with all these columns and Insert/Update with getdate() before/after defrag.
If I want to use a reference table, Is there a prebuild list available for the names?
Nope this doesn't work. It only returns 1 row.DECLARE @names TABLE( names varchar(20))INSERT INTO @namesSELECT 'mike'UNION ALLSELECT...
Hi All, I need a query to that will return similar names. For an example, if i search for mike, it should also return michael. Is this possible in...
- SQL Server 2000 -Transactional Replication- 1 subscriber - Distributor and subscriber on the same server- Subscriber always online Would you...
This seems like a network issue.
Rebuilding the index could cause this. Use SORT_IN_TEMPDB option when rebuilding indexes.
I think it will backup to one device. I would create one plan per database.
It seems like you have a corruption. Check out the following links http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55996...
You could truncate log after restore if you wish.
Follow Frank's advice. If you still want to create a table for each day, you need to create and insert using dynamic query like below:DECLARE...
You could also use : SELECT a.zipcode, z.zipcode FROM AgentAddresses a LEFT JOIN ZipCodes z ON REPLACE(a.zipcode,'-','') = z.zipcode
It doesn't work. Either use IF statement or run the whole query dynamically.
I created this stored procedure to Rebuild indexes based on the average fragmentation percentage value. It works pretty well for me. I thought of...
This worksIF @db_name = 'pubs'BEGIN USE pubsEND ELSE BEGIN USE other_db END
ok thanks. I was trying to avoid the second scenario because i have multiple queries joining many tables.
Hi All, I am tyring to use the dynamic use statement in a stored procedure using the following script. The script runs successfully but it doesn't...
In SSMS, Expand Replication - Local Publication all the way down, right click publication and go to properties. It will show under Subscription...
How about populating a temp table from each query? Also consider indexes.
Online index operations are available only in SQL Server 2005 Enterprise Edition.
Separate names with a comma.
