Viewing 15 posts - 38,761 through 38,775 (of 49,552 total)
Like this?
SELECT
tbl_index_ticket_services.ServiceID,
tbl_lookup_type_services.ID,
tbl_lookup_type_services.ServiceType,
tbl_index_ticket_services.DateAdded,
tbl_index_ticket_services.AgentAdded,
...
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
June 1, 2009 at 10:02 am
Does the database VIPA_APP already exist on the destination server? If so, please run the following and post the results
exec sp_helpdb 'VIPA_APP'
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
June 1, 2009 at 9:59 am
Specify a join condition between either tbl_services and tbl_lookup_type_services or between tbl_index_ticket_services and tbl_lookup_type_services.
How do those tables relate to each other?
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
June 1, 2009 at 9:49 am
TheSQLGuru (6/1/2009)
The part about doing index seek/bookmark lookup when you should be doing a table scan (or vice-versa) is due to parameter sniffing and plan caching.
I must admit, I've never...
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
June 1, 2009 at 9:49 am
Can't even read the article with free membership. Oh well.
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
June 1, 2009 at 9:27 am
Chris Harshman (6/1/2009)
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
June 1, 2009 at 9:20 am
Enterprise manager's just hiding the warnings. The max size for a row is 8060 bytes. You can create the table, but should any insert try and add more than 8060...
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
June 1, 2009 at 8:04 am
Can you post the query, the table definitions and the index definitions as well please?
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
June 1, 2009 at 7:48 am
Don't bother with tran logs of model. The database should never change (it's used as a model when creating new databases or recreating tempDB). Other than that, looks OK. 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
June 1, 2009 at 6:22 am
From Books Online
Reverting a Database to a Database Snapshot
A revert database operation (specified using the DATABASE_SNAPSHOT option) takes a full source database back in time by reverting it to 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
June 1, 2009 at 5:03 am
No.
The only 'restore' you can do with a snapshot is to restore the source database from the snapshot. A snapshot isn't a complete database, it's just the original version of...
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
June 1, 2009 at 4:38 am
http://msdn.microsoft.com/en-us/library/aa933197(SQL.80).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
June 1, 2009 at 4:08 am
The tail log backup is the last of the log backups. Hence you restore it last.
You can restore it with recovery it you want, or with norecovery and then recover...
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
June 1, 2009 at 3:54 am
Means they are not currently running any queries.
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
June 1, 2009 at 1:38 am
First drop any constraints
ALTER TABLE <Table Name> DROP CONSTRAINT <Constraint Name>
Then drop the indexes
DROP INDEX <Index Name> ON <Table Name>
Then drop the column
ALTER TABLE <Table Name> DROP COLUMN <Column 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
June 1, 2009 at 1:36 am
Viewing 15 posts - 38,761 through 38,775 (of 49,552 total)