Viewing 15 posts - 38,776 through 38,790 (of 49,571 total)
mathieu_cupryk (6/1/2009)
Msg 4104, Level 16, State 1, Procedure sprGetAffectedServicesByTicketID, Line 8The multi-part identifier "tbl_lookup_type_services.ServiceType" could not be bound.
Take a look at my query, take a look at yours. There's a...
June 1, 2009 at 10:41 am
Generally we don't answer interview questions here. Interviews are for you to show what you know, not for you to memorise other people's answers. Some of those questions are fairly...
June 1, 2009 at 10:40 am
Are those drives set up as dependencies in the cluster?
June 1, 2009 at 10:35 am
I don't understand your question. If there's a cross join it's because either you typed CROSS JOIN or, if you used a query builder, because you didn't define a relationship...
June 1, 2009 at 10:33 am
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,
...
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'
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?
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...
June 1, 2009 at 9:49 am
Can't even read the article with free membership. Oh well.
June 1, 2009 at 9:27 am
Chris Harshman (6/1/2009)
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...
June 1, 2009 at 8:04 am
Can you post the query, the table definitions and the index definitions as well please?
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...
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...
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...
June 1, 2009 at 4:38 am
Viewing 15 posts - 38,776 through 38,790 (of 49,571 total)