Viewing 15 posts - 8,161 through 8,175 (of 13,469 total)
I agree with Gus, it's not all that easy; At first,i couldn't think of how to do it in a single query and thought i might using a cursor for...
February 8, 2011 at 7:52 am
my first instinct would be to confirm that the objects that appear in this list need to be scripted to move their clustered index to the default partition(or dropped), and...
February 7, 2011 at 3:09 pm
could it be that the step is running in the master database instead of the db the proc is in? what if the command was changed to have the full...
February 7, 2011 at 1:52 pm
the error "string or binary data would be truncated". is specific to char/varchar fields...it doesn't have anything to do with integer fields.
since the command you are using doesn't even touch...
February 7, 2011 at 12:42 pm
This should help you Find all the traces on the server, and builds the commands to stop/drop the trace as well...
avoid using the command to drop teh default trace(is_default =...
February 7, 2011 at 12:11 pm
I think we'd want to see the actual execution plan to be sure, you might benefit from posting that.
i think the issue is going to be related to this:
AND (endDate...
February 7, 2011 at 11:46 am
wouldn't this occur if the indexes were being rebuilt with the option SORT_IN_TEMPDB?
February 7, 2011 at 9:50 am
paging your data requires some sort of key...whether it's the PK/identity of the table, or by using row number.
assuming you have a "Next" button on your application to get the...
February 7, 2011 at 7:41 am
Brandie iIm pretty sure it works for 2000/2005 instances, but i don't have a non-default 2008 or R2 to confirm that snippet still works yet.
thanks for the kudos!
February 7, 2011 at 7:31 am
are for the gory details, you can run this query to detect the ports for all your instances, or go to this property panel to see and change the...
February 7, 2011 at 7:10 am
The usual answer: it depends on the view, and the data that is in it. when it's a simple join of multiple tables, you can often update the view directly.
if...
February 7, 2011 at 6:34 am
the stored procedure you are calling...does it references the table that the trigger is on?
the trigger has got a lock on any rows that are being inserted/updated/deleted...so if the stored...
February 4, 2011 at 9:54 am
as bitbucket stated, you need to re-evaluate the requirements...noone will ever need to actually view that many transactions without filtering it for relevancy, so don't go down that rabbit hole....
take...
February 3, 2011 at 2:48 pm
there's an extra option for raiserror so you can get immediate feedback; with nowait, and that shows up immediately in SSMS:
here's an example:
--print error immediately in batch
declare @i int,
...
February 3, 2011 at 12:28 pm
Zeal-DBA (2/3/2011)
February 3, 2011 at 8:37 am
Viewing 15 posts - 8,161 through 8,175 (of 13,469 total)