Viewing 15 posts - 42,151 through 42,165 (of 49,571 total)
Paresh Prajapati (12/26/2008)
Take transaction log backup of database and apply on that server with recovery.
How's that going to help with creating a second copy of an in-recovery database without breaking...
December 27, 2008 at 2:55 am
Pavas Malviya (12/26/2008)
c++ is bad. But good at c#
But you can't write extended procs (as far as I know) in C#.
December 27, 2008 at 2:53 am
leonp (12/24/2008)
We have perfmon running for 3 hours; thrice a day. Sampling once every 75 seconds. Is that a bad thing?
Not perfmon. Profiler.
Select * for the reader (which the...
December 24, 2008 at 7:34 am
Michael Earl (12/24/2008)
At least they were able to open Management Studio and run the query.
Well there was this one guy (who claimed to be a performance tuning guru and have...
December 24, 2008 at 7:33 am
Michael Earl (12/24/2008)
December 24, 2008 at 5:46 am
Where CancelFlag = 0
A bit holds values of 1 or 0. By convention, 0 is false and 1 is true, though there's nothing in SQL that enforces that.
December 24, 2008 at 3:04 am
Doesn't look like memory bottleneck either.
If the app's inserting a lot of new data, then the PLE will be low because new data's constantly coming in.
Do you have SQL profiler...
December 24, 2008 at 1:44 am
jasmineywchen (12/23/2008)
My questions and concerns are:1. When the base tables are being written, is it going to lock the tables causing the view to timeout??
Probably not the entire table,...
December 24, 2008 at 1:25 am
SQLBill (12/23/2008)
December 24, 2008 at 1:14 am
Lee From Bangalore (12/23/2008)
While taking the backup if the database is currupted what will we do?
Depending on the severity, fix the corruption, or restore a clean backup.
December 24, 2008 at 1:11 am
Save as a .sqlplan file, zip and attach to the post.
December 23, 2008 at 11:43 pm
Check in Books Online, under sys,dm_exec_sql_text. There are examples there.
December 23, 2008 at 11:41 pm
Grant Fritchey (12/22/2008)
Gail Shaw had some interesting sample code around COUNT methods in her SQL Pass Presentation. It might be on her blog.
Or it might not. At least right at...
December 23, 2008 at 10:57 am
What is this supposed to do?
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 23, 2008 at 10:35 am
None. The TS exam is a prerequisite for the two ITPs, but that's it.
This site should answer all of your certification questions - http://www.microsoft.com/learning/mcp/certifications.mspx
December 23, 2008 at 10:30 am
Viewing 15 posts - 42,151 through 42,165 (of 49,571 total)