Viewing 15 posts - 16,501 through 16,515 (of 39,827 total)
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
Red Gate's SQL Compare will not do this. It looks at the tables, but I'll ask and see if there's an option, or file a bug.
Disclosure: I work for Red...
March 18, 2011 at 5:07 pm
I'm knocking off, but here are the first two days results as of now (5pm MST)
Johan: 4, 1 team gone, 3 left to play today
Allen: 3, 3 teams gone, 2,...
March 18, 2011 at 5:01 pm
Too late this year, but I'll keep you in mind next year, Ray.
March 18, 2011 at 4:58 pm
I'm not sure what that would do to the RSS feeds. Right now those are by forum, and adding in feeds by tags complicates things immensely. I'd like to say...
March 18, 2011 at 3:56 pm
I have tried to slide SSIS questions to the Integration Services forum (http://www.sqlservercentral.com/Forums/Forum364-1.aspx) under the data warehousing forum: http://www.sqlservercentral.com/Forums/Group408.aspx
I could do an SS2K8 specific one, but I'm not sure...
March 18, 2011 at 3:16 pm
Viewing 15 posts - 16,501 through 16,515 (of 39,827 total)