Viewing 15 posts - 2,236 through 2,250 (of 7,498 total)
Now jou've hit another typical "project progress" issue.
It will need to come to a good collaboration between the dba(-team) and the dev(-team).
Actually the lac of this collaboration model already costs...
March 13, 2011 at 9:37 am
generally we solve this kind of problem using e.g.
select ...
from ...
where yourdatecol >= GETDATE()
and yourdatecol < DATEADD(dd, datediff(dd, 0,getdate()) + 1,0)
Don't use "between" because that may cause...
March 13, 2011 at 4:58 am
By now you should have a solution for your problem using the proposed hints.
I just wanted to mention I encountered a case study regarding join performance when using strings vs...
March 12, 2011 at 10:43 am
because sqlserver needs a 4-part name to access a linked server.
Your 3-part name is translated to the instances own DB.schema.object
March 12, 2011 at 10:35 am
One should always be reluctant when you find an Implicit conversion.
In this case, the engine determined to convert your nvarchar column to integer.
It's called "Data Type Precedence" and documented...
March 12, 2011 at 10:31 am
Ninja's_RGR'us (3/11/2011)
LutzM (3/11/2011)
Ninja's_RGR'us (3/11/2011)
Actually it doesn't :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:
Easy fix: the line break < br > is part of the link. Remove it from the end of the link to see the...
March 11, 2011 at 1:59 pm
It tells you sqlserver is wasting plan cache space by storing plans that aren't being reused.
I implemented this attached job on instances where I proved they suffer this waste of...
March 11, 2011 at 1:52 pm
I think you are a bit confused regarding what actually is dbmirroring.
It is another HA technique for SQLServer.
It needs modification of all connection strings to be effective.
A connection needs to...
March 11, 2011 at 10:49 am
Indianrock (3/11/2011)
ALZDBA (3/11/2011)
Can you elaborate on the "We seem to have solved a major IO problem last weekend so we'll see how long it runs this weekend." ?
...
March 11, 2011 at 10:39 am
Michael Valentine Jones (3/11/2011)
March 11, 2011 at 10:30 am
Ninja's_RGR'us (3/11/2011)
That link is not working atm.
I'm sorry.
It was indeed a faulty placement of the begin tag for the url. :blush:
Thank you Indianrock for fixing it. :Wow:
I fixed it in...
March 11, 2011 at 10:22 am
I hope you're not using ntfs compressed drives (luns) ! This is one of the worst things you can do.
What's the page life expectance for this instance ?
March 11, 2011 at 9:45 am
Yes you can, as long as it doesn't need to use SQLDMO to create objects.
March 11, 2011 at 8:49 am
Like Gail suggested, you really need to ask you manager for clarification.
Some managers tend to use turbo language and invent their own slang to try to get things done.
It's up...
March 11, 2011 at 8:48 am
it (sqlserver) keeps records for all mails it sends.
This is something you need to take into account.
We have dbmail enabled on all our sql2005 and > instances to monitor for...
March 11, 2011 at 8:40 am
Viewing 15 posts - 2,236 through 2,250 (of 7,498 total)