Viewing 15 posts - 12,271 through 12,285 (of 22,214 total)
Nope. Identity is a number field. It would need to go into a number data type such as int or bigint. What you could do is create a calculated field...
June 17, 2011 at 3:48 am
Not seeing the query or the execution plan, I have no idea.
As a guess, I'll go back to what I said before, you're getting timeouts on the optimization process and...
June 17, 2011 at 3:22 am
First thing was the integration with my Droid phone. It was seemless. Once I had logged into Google, all my data was moved across to the Asus, like magic. Second,...
June 16, 2011 at 5:04 pm
GilaMonster (6/16/2011)
June 16, 2011 at 8:24 am
Roy Ernest (6/16/2011)
Grant Fritchey (6/16/2011)
Roy Ernest (6/16/2011)
Grant submitted a session on how to write good abstracts. 🙂 Maybe we can ask him to write an article up on it. 🙂
Yeah,...
June 16, 2011 at 7:43 am
ESAT ERKEC (6/16/2011)
But i want to ask one think what about cpu and read options Cpu can be used separate files?
Well, yes, CPU is used to determine what goes where,...
June 16, 2011 at 7:15 am
You're going to have to rewrite everything.
Sorry.
The thing is, if you try using linked servers, what happens is, let's say you join two tables across databases, in a single server,...
June 16, 2011 at 7:11 am
The suggestions already posted for a heartbeat monitor are fine. But if you really want to tell the operator "what is wrong" other than the server is there or not...
June 16, 2011 at 7:06 am
I've started using an Android tablet, the Asus Transformer, instead of the iPad. I'm much happier with it as a production device as well as a consumption device.
That said,...
June 16, 2011 at 7:03 am
Multiple files, but a single drive? I'm not surprised that performance is better with a single file. You're asking SQL Server to do extra work to distribute the data, but...
June 16, 2011 at 7:01 am
Roy Ernest (6/16/2011)
Grant submitted a session on how to write good abstracts. 🙂 Maybe we can ask him to write an article up on it. 🙂
Yeah, but that session got...
June 16, 2011 at 6:56 am
The thing is, you're running 2005 and 2000. They are two totally different optimizers. There were a number of upgrades in the engine as well as changes, stuff was fixed,...
June 15, 2011 at 9:03 pm
WayneS (6/15/2011)
June 15, 2011 at 8:58 pm
ALZDBA (6/15/2011)
jcrawf02 (6/15/2011)
Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing,...
June 15, 2011 at 1:37 pm
I've nominated a couple of people from this list and, as far as I know, nothing has come of it. I must write bad recommendation letters.
June 15, 2011 at 12:05 pm
Viewing 15 posts - 12,271 through 12,285 (of 22,214 total)