Viewing 15 posts - 76 through 90 (of 193 total)
50 Characters? That's not a column name, that's an essay!
October 26, 2009 at 3:20 am
The statistics are created when you have Auto Create Statistics set to on. They are used by the optimiser when it's working out which way of running a query...
October 23, 2009 at 2:18 am
What's your index fragmentation like? Are you doing regular rebuilds/reorgs?
October 16, 2009 at 10:12 am
Or at least someone asking "WHY are you doing this?"
Or arguments pointing out issues as highlighted in http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/13/629059.aspx perhaps?
October 7, 2009 at 4:31 am
Ewan Hampson (10/1/2009)
Roy Ernest (10/1/2009)
Then the normal users will not be able to connect to the DB V-LAN with their excel and access.
But we all know the users have got...
October 1, 2009 at 8:29 am
Silverfox (9/29/2009)
Depends on the company mostly, if you have third party apps, they tend to depend on using sql logins.
SQL Logins. Plural? Thought most TPA's just used sa?...
October 1, 2009 at 7:16 am
The point Grant is making is that if you have a 'problem' database - then in order to prevent it impacting on other databases on the server - the solution...
September 29, 2009 at 8:31 am
Then when you have your disaster recovery strategy and documetation - with a copy of the plan stored safely offsite with your offsite backups, test, refine, test refine, test refine.
If...
September 10, 2009 at 6:50 am
For and non-trivial system, I'd go for
OLTP - Normalisation
Reporting - from datawarehouse using dimensional modelling
September 9, 2009 at 10:18 am
MD (5/9/2008)
Agree with others here. Of course, this is a good way to ensure job security as someone will have to clean this mess in the future
Don't get much...
September 8, 2009 at 7:21 am
465789psw (9/3/2009)
hard to tell, we need the qry plan. The engine should run one then run the 2 sec one then add them together.
No. When you combine views...
September 3, 2009 at 10:25 am
Without being able to see the query plan - can't say for certain, but I have in hte past seen similar types of degradation (or even worse) using derived tables...
September 3, 2009 at 10:14 am
I'm with Gail on her assessment of your boss's 'strategy'.
Firstly - just because you *can* do something, it does not follow that one should. It is possible to cross...
September 2, 2009 at 5:42 am
I'd look for "A Dimensional modelling Manifesto" by Ralph Kimball, a great start to designing reporting systems using dimensional modelling. In fact anything by Ralph Kimball on the subject
September 1, 2009 at 5:01 am
Based on that dataset, using something like
SELECT DATEPART(YEAR,
CAST(
CASE ISDATE( a)
WHEN 1 THEN a
ELSE
RIGHT(REPLACE(a, ' 00:00:00', ''), 4) +
SUBSTRING(REPLACE(a, ' 00:00:00', ''), 3, 2) +
LEFT(a, 2)
END
AS DATETIME
)
)
FROM...
August 21, 2009 at 2:40 am
Viewing 15 posts - 76 through 90 (of 193 total)