Viewing 15 posts - 2,236 through 2,250 (of 7,502 total)
FYI - Maybe you can find some help and advise in this "Advantages to Using Stored Procedures over ORM Tools" by Idera.
March 14, 2011 at 8:05 am
Yesterday I encountered a nice list that will be a very good starting point:
March 14, 2011 at 1:36 am
You have a great tool set at your disposal.
If you also have their query optimizer, your biggest challange will only be the collaborative model.
March 13, 2011 at 11:17 am
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
Viewing 15 posts - 2,236 through 2,250 (of 7,502 total)