Viewing 15 posts - 16,636 through 16,650 (of 39,970 total)
The problem comes in when T-SQL grows and what was an acceptable word in the previous version is not in this one.
March 21, 2011 at 3:57 pm
The RDBMS, adhering to some strict academic definition or not, is certainly not dead or a dead end. It works extremely well for many solutions. There might be improved ways...
March 21, 2011 at 12:46 pm
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
Viewing 15 posts - 16,636 through 16,650 (of 39,970 total)