Viewing 15 posts - 9,691 through 9,705 (of 22,213 total)
A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but you still...
July 30, 2013 at 8:04 am
Spools are a way for the query engine to store data, either for reusing it, or for rollbacks (other situations too, imagine where it might need to keep stuff for...
July 30, 2013 at 8:01 am
I'm cool with anyone handling backups. As long as they get done and (the kicker) as long as we can successfully restore them in a timely manner. If it takes...
July 30, 2013 at 7:58 am
WayneS (7/29/2013)
Just curious - how many like that new tile look on the home page?FWIW: I prefer the older images over these tiles.
It's all http://www.youtube.com/watch?v=0pRUGsB1qGY all the time, everywhere.
July 29, 2013 at 12:23 pm
HowardW (7/29/2013)
Grant Fritchey (7/23/2013)
July 29, 2013 at 9:14 am
They have relaunched the project and something should be coming out ... soon? I don't have any dates or date estimates for you. Sorry. But, I think, possibly, this fall....
July 24, 2013 at 1:11 pm
In general, partitioning is not a great mechanism for improving query performance.
Without seeing the query or the execution plan, I'm only guessing.
It sounds like the order in which the...
July 24, 2013 at 1:08 pm
Be careful with the UDF. An in-line UDF is fine, but a multi-statement table valued UDF could lead to serious performance bottlenecks.
July 24, 2013 at 5:06 am
Pretty much all of what you're looking for is available in sys.dm_exec_requests dynamic management view. Take a look there.
July 24, 2013 at 5:03 am
Are they inserting data into the regular tables and then updating it in place as part of a single operation?
If so, your approach could possibly work. But what about just...
July 24, 2013 at 5:02 am
shane.streeting 51351 (7/24/2013)
At the risk of asking a question that's already been answered, i too am running sql server 2008 Standard Ed v10.0.5500.0
Everything i've read says that online index rebuilds...
July 24, 2013 at 5:01 am
You could be seeing a number of different things. It could be simple contention on resources, other processes are reading/writing to the table you need, so you're waiting, or the...
July 23, 2013 at 9:29 am
It's pretty normal behavior. Do you have log backups in place? If not, is the database in Simple recovery mode? If not, you need to setup log backups.
July 23, 2013 at 9:22 am
It could be a security issue. You and the login that is running SQL Agent may not have the same privileges. It may be a settings issue such as the...
July 23, 2013 at 9:11 am
Viewing 15 posts - 9,691 through 9,705 (of 22,213 total)