Gift Peddie (12/13/2009)

---

I installed VS2008, SQL Server 2005 and SQL Server 2008 now Windows 7 complain about VS2005 not compatible but I ignored that. If try all programs in...

on your laptop, this probably seems to make sense....everything "else" slows down, and task manager says sqlserver.exe is using almost all your memory.

As Bru and Lynn both pointed out, it's...

there are two kinds of hotfixes: cumulative hotfixes and specific hotfixes;

for example this link:

http://support.microsoft.com/kb/918222 clearly descibes that this is the latest cumulative hotfix as "build 2153" for SQL 2005...so yes,...

converting an rtf string to raw text.

AFAIK, you can't uses a System.Windows.Forms.RichTextBox in a CLR, but you can call a web service that uses the System.Windows.Forms.RichTextBox;

two steps to...

Grant, would this be a correct assumption?

if the index for date_entered was in place, would we expect an INDEX SEEK and an estimated 10 rows(because of the TOP 10) instead...

ok I'm no expert, but I'm not a country bumpkin either.

it looks to me like this is the costliest item: a table SCAN of almost 500,000 rows, which then requires...

altering a procedure is NOT the same as EXECUTE ing the procedure.

run something like this statement and capture the query plan :

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

EXECUTE GetOrders @params.....

then run the...

sp_depends yourtable

select * from sysdepends where object_id(id) = 'YourTable'

this will accurately identify any dependencies help by views or functions and is accurate for most procedures; however, because of a feature...

your joins look a little funky, and you are missing an AND in the join.

pseudo code sucks, because it hides real issues(table1,table2,etc...column1,column2, etc)

...you should show the real code you were...

the trick is to use the CHARINDEX function to find the dash....potentially it could be in a different place than your example

this might get you started:

create table #example(SOC_MAPPING varchar(1200) )

insert...

using a function on a column in the WHERE statement slows things down because it's not SARGable...that is a searchable argument that can be take advantage of the indexes...

That's weird Mark;

SQL 2000 would automatically dummy itself down to the Desktop version if you installed SQL 2000 Standard or Enterprise on a non-Server OS, but every time I've ever...

shouldn't you just change the first table in the query to be refTrkNonAdmitReason as the base table, and join everything to that in order to get zeros for all reasons?

SELECT...

i am completely spoiled by 2005 i swear.

assuming you create this tally table complements of Jeff Moden:

--===== Create and populate the Tally table on the fly

SELECT TOP 11000 --equates...

oops didn't notice the 2000 forum; easy to fix; here is the same solution, but witht he TallyCalendar as a correlated subquery instead:

DECLARE @mn datetime,

...