Viewing 15 posts - 2,266 through 2,280 (of 7,504 total)
SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Another vitamin boost by SQLkiwi 🙂
March 4, 2011 at 10:05 pm
Gianluca Sartori (3/3/2011)
We're still working on the issue with MS support.
Now they're trying to reproduce the problem on their own,...
March 4, 2011 at 12:58 pm
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
Viewing 15 posts - 2,266 through 2,280 (of 7,504 total)