Search results for query: *

I have a sp which populates a table. the SP resides on the same server/db as the table. Several of the values are assigned nulls and then inserted into the table. I have 4 defaults on some of these fields. However, instead of loading the default it puts a blank. ANy ideas

We have a server (win 2003 sql server 2000) which had the latest MS patches applied on 3/23. The db server is a dell quad attached to a dell storage array. Ever since this patch we have noticed considerable slowdown in performance. Nothing much has changed as far as the db is convcerned...

Looking at below, it does not error out but also does not return what we are expecting form_ind = case when (select count(*) from fdb_medication fm1 where fm1.gcn in (select distinct fm2.gcn from medication_payer_mstr mpm inner join fdb_medication...

I have sql 2000 Ent running on Win 2003. My Cache hit ratio is running around 66%. TIme for more memory. Also, is there a way to show what specific objects are chewing up memory? This is 3rd party apps so changing app not an option

Anyone had any good experiences with SQL 2005 training with Clusters. I am in St. Louis, and training for this is a little thin. I thought there was some in Colorado or Chicago

I have 2 fields one with date like below, other is time like below but no milliseconds. Other than manully adding in all / and : is there a faster convert to combine the 2 for date/time comparison date time 20060303 150000 20070601 120000

Anyone had any luck with 3rd party vendors going from sql 2005 to Oracle 9. I have heard some of the 3rd part offerings are much faster than the MS or Oralce solutions

I have some data loaded from a mainframe looks like below lastname firstname id smith john 12 moris cal 13 The problem is there are what I thought were white spaces at the end of the names. I tried below on test table and with...

If I have stored proc A which sends a value to be processed by stored proc B, but stored proc b errors out. If I have stored proc B return on error, is the @@error available for Stored proc A, or is the scope limited to B?

We have a 3rd pary app coming in that needs to run on several sql 2005 Servers. Our network ops wants to run one active/active cluster and then another instance of sql 2005 on the same box. I didn't think this was possible? Any opinions appreciated

I have an INQ table which has a date field, orderid and a request type which is actually a big xml string. the data looks like this <NewOrder><SiteID>CJC</SiteID><patID>458887</patID><LName>Cronin</LName><FName>tim</FName><EntryID>{7B1A4946-CEC8-4F23-AE89-5C70A6A0F9B2}</NewOrder> Why I need...

On sql 2000 Ent Edition I have 5 db's setup for log shipping. Now it seems the delete file portion has stopped working. ANyone seen this before?

To get an accurate up to data row count on a table, is select count(*) from table where autodate is null still the most Efficient way, for some reason I thought there was something better

I have an older client server app which uses ODBC to attach to sql 2000. If the database option for quoted identifiers is not set, but they are set on the odbc side who wins. We have been having a problem with one of the clients with a crystal report and I believe this may be the source

My developers have an application using 3 databases called mardemo,mardemowh,mararchive. However when the solution is deployed to the user the db's name will be changed per client. Since several sp.'s have joins and other processes that use the dbname, they have to be changed for each client...

Trying below to update just the year on a field, syntax is incorrect. is there a better way to do this Update p_lab_results_obr set year(COLL_DATE_TIME) = year(SPEC_RCV_DATE_TIME)

When running perfmon on a sql 2005 box I get the below Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error message: Access is denied. Source: SidebySide EventID: 59 Generate Activation Context failed for D:\Program Files\Microsoft SQL...

I have a 3rd party app which has a clustered unique index on 2 fields, and then another unique index on the same 2 fields are 3 others. I have been having some errors coming back from my monitoring software with this table. With 2 unique indexes aren't I asking for a lot of extra overhead with...

I have a sp created by a developer from a 3rd party db (can't change the structure) that is used for a crystal report. I understand her need for this logic but it is pretty brutal on the db side. It has to do several unions. Anyone have a better approach? CREATE procedure...

I have the function below, can you not use getdate() in a function. It tells me Invalid use of 'getdate' within a function. alter function [dbo].[fnGetOrderAlertsandMessages](@orderid int ) returns varchar(350) as begin declare @ret varchar(350) select @ret = coalesce(@ret+', ', '') +...