Viewing 15 posts - 38,821 through 38,835 (of 49,552 total)
WayneS (5/28/2009)
I've seen several mentions of a "catch-all" query, where the "where" statement has several conditions in it.
My definition of 'catch-all' (for what it's worth) is a query that has...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2009 at 2:01 am
Split them out into subprocedures. The reason is parameter sniffing.
When the proc is called the first time, the entire procedure is compiled and optimised based on the values of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2009 at 1:57 am
Sounds like you're good to go.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2009 at 1:50 am
sp_change_users_login (deprecated) or ALTER USER
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 4:06 pm
It's telling you that there's a dependency entry for the procedure that references a column that does not exist in the view. (It can't be the other way around because...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 3:28 pm
Yes, absolutely. From 2005 SQL allows you to mirror the backup files to 2 (or more) locations. They must both be the same type of device (eg both disk or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 2:53 pm
Bob Hovious (5/28/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 2:43 pm
Status is not, as far as I'm aware, a SQL system table. Speak to whoever developed that system.
I honestly can't see how to get 12:16 pm out of that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 2:15 pm
I thought I'd seen everything....
Anyone (preferably someone who's telepathic or precog) want to tackle these?
http://www.sqlservercentral.com/Forums/Topic725415-8-1.aspx
http://www.sqlservercentral.com/Forums/Topic725410-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 2:02 pm
That's not a SQL system table. Ask the developer or vendor if it's a purchased piece of software
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 2:01 pm
What time does the example value that you posted equate to? Did you get this from one of the SQL system tables?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 1:59 pm
Roy Ernest (5/28/2009)
GilaMonster (5/28/2009)
Cricket. The only game that you can watch for 5 min every 2 hours and still catch all the action.
That has changed with the introduction of 20/20....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 1:52 pm
Which table are you talking about?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 1:51 pm
Cricket. The only game that you can watch for 5 min every 2 hours and still catch all the action.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 1:41 pm
Do you ever do any queries on that table?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 1:37 pm
Viewing 15 posts - 38,821 through 38,835 (of 49,552 total)