Viewing 15 posts - 2,326 through 2,340 (of 7,502 total)
- Is there any other connection connected to your database ?
- is there any blocking going on for that database ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 17, 2011 at 12:10 pm
hydbadrose (2/15/2011)
... restore the TDE database on same server....
this is the obscure part ... I interpreted it as database name, not encryption related.
You can have more than one...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 16, 2011 at 12:09 am
just keep in mind you cannot restore Ent edition backups to Std edtion if you are using Ent Edtn features ! (partitioning, ...)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 10:50 am
books online will have all the examples you need to start with.
topic "restore"
When using sql server management studio, you can also have it restore your database to a new...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 10:19 am
keep in mind the engine states the error on your object 'dbo.Command' !
You'll have to investigate that table ( i assume ) and the indexes, constraints, .. on it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 10:13 am
In a clear moment you may be able to spot this kind of things .... if you have been bitten by it yourself frequently enough 😀
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 6:27 am
While it is fun conversing about the situation and the brain storm sessions about it, it'll not be fun for Gail.
As much as I have the impression supporting software vendors...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 1:07 pm
Actually you've posted a nice example on how partitioning with sliding windows can help out very much when trying to keep "current" tables small and not losing online data with...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 11:35 am
I think your only resource then would be
DBCC ind ( <database_name>, <table_name>, non clustered index_id*)
Have a look at Paul Randal s blog for more info of dbcc...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 11:03 am
IMO you are fooling yourself by using the wrong PF with the correct table in your select query.
SELECT *
, $PARTITION.AnnualDateRange_PartitionFunction(OrderDate) AS PartitionNumber
,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 10:46 am
Have a look at "Managing Space Used by Objects" for the internals, how the engine manages it all.
Have a look at the poster Aaron Bertrand points to: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/01/28/sql-server-2008-system-views-poster-is-now-available-for-download.aspx to get...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 10:34 am
I've been out for the day :Whistling:
Anyway, any rollback statement will undo your whole transaction (including the original inserts and other stuff in the same transaction scope), so be careful...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 10:22 am
did you manage to get your install corrected ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 3:49 am
just came across this art today at sqlblog : http://sqlblog.com/blogs/davide_mauri/archive/2011/02/13/sys2-scripts-updated-scripts-to-monitor-database-backup-database-space-usage-and-memory-grants-now-available.aspx
Maybe this can help you out.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 3:48 am
Jeff Moden (2/13/2011)
gary.morey (1/31/2011)
Thank you. That did it!Heh... stop using font sizes, Gary. The defaults are just fine. 😉
I thought he was whispering it and SSC doesn't supply...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 13, 2011 at 12:08 pm
Viewing 15 posts - 2,326 through 2,340 (of 7,502 total)