hit the key combination [ctrl] + [shift] + [R], that causes the intellisense to refresh the current window. It usually only gets the object names once when you first...

wayne.mcdaniel (3/30/2012)

---

- Warn the user the database is going down, and everyone needs to log off

- get the physical file names and locations

- put the database in single user mode

-...

you may want to check if there's a different execution plan used when the proc is called from management studio vs. the application. One of the culprits to check...

interesting problem, I think windowed functions work well here:

SELECT RelationshipID

, ParentID

, ChildID

, RoleID

, StatusID

...

seems to be a common problem, converting anything from...

actually I think it's the explicit conversion to FLOAT that messes up both of our solutions not any implicit conversion, so ColdCoffee's solution may be brute force, but without an...

how about something like this to figure out the most decimal places used in the table:

SELECT MAX( CHARINDEX('.',REVERSE(CAST(CAST(val AS float) AS varchar(11)))) -1 )

FROM tablename

WHERE...

I think the problem is by default, severity 11 errors don't get logged, and SQL Server will only...

I'd have to say the car that best describes me is an early 90's Acura Integra. Not too flashy, but gets you where you're going quickly, efficiently, and very...

What your solution does is create a triangular join, which will not scale well in a real world situation with more records than your sample. The article Eugene posted...

ssdba (3/6/2012)

---

...Row versioning was an option that had come to mind, but wasnt sure it would help. Was trying to take the more conventional route by either creating specific indexes...

Is this system an OLTP system? Are you able to determine if the deadlocks are being created by writes blocking writes or are there some caused by reads?

If writes...

I'm not sure that MSDN link really answers your question. If you're referring to the actual tables in a SQL Server database then no it doesn't make sense to...

A very good solution I've been using for a couple years now is at:

http://www.cozyroc.com/

They have a number of usefull task components in...

[RANT] Nothing wrong with the question or answer, but I do have a comment on Microsoft's implementation of SQL Agent security. In typical Microsoft way it's confusing by role...