Viewing 15 posts - 2,266 through 2,280 (of 7,498 total)
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
Do you want to return all last names in a single return field or do you want to return a set of all last names ( row based ) ??
If...
February 26, 2011 at 1:06 am
search Books Online on "GROUP BY clause, AVG function".
You'll find nice examples of what you need.
February 26, 2011 at 12:56 am
I'm not going into details on this one. It's been couvered totally already.
RBarry, it is ok to refer to your series of article on how to lose the cursors and...
February 26, 2011 at 12:46 am
Viewing 15 posts - 2,266 through 2,280 (of 7,498 total)