Viewing 15 posts - 16,591 through 16,605 (of 39,922 total)
A few scripts that might help: http://www.sqlservercentral.com/search/?q=copy+backup+to+server&t=s
March 21, 2011 at 11:06 am
The index spool is expensive (http://ask.sqlservercentral.com/questions/6268/what-is-index-spool)
However I'm not sure what you're trying to do with the indexed CTE or using triggers to update a table. Is this queried often and...
March 21, 2011 at 10:35 am
First, you really need to think about breaking this down and hiring someone with experience. I understand the boss might not want to do that, but perhaps you can collect...
March 21, 2011 at 10:25 am
You'll have to test things. There isn't a way to be sure what's best, but here are a few suggestions. Note that the "view" isn't run, but incorporated into the...
March 21, 2011 at 10:11 am
Revenant (3/21/2011)
For a fine-tuned, high-performance system I would recommend a complete performance review after each service pack. It is time-consuming and therefore expensive, but it it prevents unpleasant surprises.
Do...
March 21, 2011 at 9:45 am
I'd argue that SQL needs a replacement, or that RDBMSes are fundamentally flawed. They have fueled and supported a tremendous data explosion and amazing amount of business.
That being said, they...
March 21, 2011 at 9:36 am
It's been fun, watching the wins over the weekend. Would be better if we could harass each other in the hallways, but it's still fun.
March 21, 2011 at 9:31 am
Suppose you had created a column with the name "desc" as in
Create Table Customer
( CustomerID int
, CustomerName varchar(100)
, Desc varchar(max)
)
If you wanted to select the data
SELECT
CustomerID
, CustomerName
,...
March 21, 2011 at 9:28 am
Well, Johan is leading the way. Not quite running away but with 3 teams and 9 points, he is in good shape. The standings
Johan, 9 pts, 3 teams
Bradley, 8 pts,...
March 21, 2011 at 8:57 am
Is this with shrinkdatabase or shrinkfile?
March 19, 2011 at 11:11 am
Craig Farrell (3/19/2011)
AnyWayDBA
Following
March 19, 2011 at 10:19 am
phelmer (3/18/2011)
March 19, 2011 at 10:18 am
March 19, 2011 at 10:12 am
You'll have to show some code and execution plans here, but in general, you want to create indexes on the fields that are being joined and potentially the aggregates.
However the...
March 19, 2011 at 10:11 am
It shouldn't affect anything. This is a meta data change that takes a shared lock on the database, but it should not affect any transactions
March 19, 2011 at 10:09 am
Viewing 15 posts - 16,591 through 16,605 (of 39,922 total)