Viewing 15 posts - 9,661 through 9,675 (of 22,213 total)
If you've issued a kill command, you now have to wait for the rollback to complete. That can take as long, and sometimes longer, than the original transaction. So, if...
August 14, 2013 at 5:02 am
Usually you'll be looking at one of two scenarios. You're going to be accessing the WASD database from a web page, also residing in Azure. There you don't have to...
August 14, 2013 at 4:55 am
Both are "safe" approaches in that a given partition scheme can be applied to different tables. You just create a function (from the Books Online):
CREATE PARTITION FUNCTION myRangePF1 (int)
AS RANGE...
August 14, 2013 at 4:50 am
Order of preference:
Tune the query
Adjust the indexing
Materialized view
Staging table
Analysis services
But the order of preference mostly also reflects how often these are used and how well each works (although SSAS works...
August 14, 2013 at 4:44 am
It's mostly been in the October/November time frame. More often in October.
Too much sarcasm in the article or not enough?
August 14, 2013 at 4:39 am
HowardW (7/17/2013)
Grant Fritchey (7/17/2013)
GilaMonster (7/15/2013)
About bloody time too...Third!
Is there confirmation somewhere that they've actually dropped it, or is it just that they haven't bothered with the CTP?
I've heard nothing one...
August 7, 2013 at 4:10 am
BrainDonor (8/7/2013)
GilaMonster (8/6/2013)
Chad Crawford (8/6/2013)
They did a movie too[/url] - wasn't too good, but I thought it was worth watching because I loved the series so much.
The movie's good...
August 7, 2013 at 4:05 am
From a purely technical point of view, short names don't hurt. They don't help either. A shorter DB name won't make backups run faster, queries run faster or decrease the...
August 2, 2013 at 8:59 am
RonKyle (8/1/2013)
August 1, 2013 at 11:51 am
RonKyle (8/1/2013)
RonKyle (7/31/2013)
--------------------------------------------------------------------------------
Most would probably say it's overkill, but I prefix my OLTP databases with db, my staging areas with sa, and my OLAP database with dw. The names are...
August 1, 2013 at 8:27 am
Nemeaux (7/31/2013)
So what do you all think about database names as short as 5 characters in length? Which is a standard that is mandated where I work?
Same question, why? What...
August 1, 2013 at 6:59 am
RonKyle (7/31/2013)
August 1, 2013 at 6:57 am
Just remember, query "hints" are not hints, they are commandments. NO_LOCK is not a suggestion that maybe, if the possibility presents itself, where applicable, avoid taking out some locks if...
August 1, 2013 at 5:42 am
I would suggest that you also use extended events to capture the execution of the queries. This will show the amount of CPU and I/O each query consumes. That will...
August 1, 2013 at 4:58 am
Clarity, clarity, clarity.
You need to make things clear. Keeping the names arbitrarily short does nothing but obscure meaning. You want to know what things are, quick, clear and simple. In...
August 1, 2013 at 4:52 am
Viewing 15 posts - 9,661 through 9,675 (of 22,213 total)