Viewing 15 posts - 2,266 through 2,280 (of 7,502 total)
yep. You'll have to re-install.
Have a look at http://msdn.microsoft.com/en-us/library/ms189852%28v=SQL.90%29.aspx
it states:
... the partners must use the same edition....
Keep in mind to apply the latest service pack !
March 4, 2011 at 5:13 am
just a side note:
You will possibly have seen 100% cpu because you still have your instance max degree of parallelism to its default value of 0 (full controlled by...
March 3, 2011 at 12:08 pm
Should be used as WITH (NOLOCK) (if you need to use it in the first place ?)
I think the ( ) is supposed to be mandatory in versions >...
March 3, 2011 at 11:58 am
imMHo the most important statement regarding virtualization by Brent'O that is to be found is :
http://www.theinfoboom.com/articles/virtualizing-databases-too-big-to-fail
It concerns the most forgotten issue with virtualization.
March 2, 2011 at 7:47 am
how about:
Select @rundate
, pm.companyid
, pm.policyid
, pm.inceptiondate
...
March 2, 2011 at 7:29 am
Chris Morris-439714 (3/2/2011)
CirquedeSQLeil (3/1/2011)
Fal (3/1/2011)
David Benoit (3/1/2011)
Grant Fritchey (3/1/2011)
Well do you want video or just pictures?Just don't put either on The Thread. Please... 😀
Hey, I thought only code was barred...
March 2, 2011 at 3:45 am
If you have nicely kept your "default trace" enabled and running, that may be a source of wisdom.
Check out this nice solution by Tibor Karaszi
"Did we have recent autogrow?"
http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx
March 2, 2011 at 12:18 am
george sibbald (2/18/2011)
It obviously can be recreated but...
March 2, 2011 at 12:15 am
Why aren't you using an SSIS app to do that in a performant way for you ?
March 1, 2011 at 6:24 am
- Can't you upgarde to use SQLCMD in stead of osql ?
- What's the reason to open xp_cmdshell to perform your sqlcmd ?
Is there a need to perform in _now_...
February 28, 2011 at 12:11 pm
have a look at what kind of fromat options convert brings.
Check Books Online. "CAST and CONVERT (Transact-SQL) "
February 28, 2011 at 12:07 pm
daveriya (2/26/2011)
what about particular day,i should add where condition.thanks
It depends on your needs.
If you want a total overview, there is no need.
Probably you'll only want e.g. last weeks info, so...
February 27, 2011 at 1:08 am
is your connection positioned in the correct database ?
February 26, 2011 at 11:00 am
Always good to post the thing you tried.
You must tell sql what you want.
You want per date usernames and the number of logins.
So this is the kind of query you...
February 26, 2011 at 10:59 am
GilaMonster (2/25/2011)
ALZDBA (2/25/2011)
It states the magical figure of 100 rows.Does it also state where that 'magical' figure comes from?
Nope.
Page 24 mentions the estimated rowcount 0 or 1 for @tv...
February 26, 2011 at 1:17 am
Viewing 15 posts - 2,266 through 2,280 (of 7,502 total)