Programming SQL

A small speed problem
Hi, In access I have this Pass-Through Query Select * From RISK.TBL_DEMAND_FINAL Where GROUPID = 2307689 which runs in a couple of minutes,the table is on a Oracle database In SQL Server 2005 I have linked to the server and run the same query Select * From Guido..[RISK].[TBL_DEMAND_FINAL] Where GROUPID =... 23 Jul 2008 10:13

SQL Developer Edition Question
Before I go buy this I want to make sure it will work. I am running Vista and I have seen that if you install SQL SP2 that it will work correctly on this OS. Just thought I would ask the experts before I make a purchase. Thanks! ... 23 Jul 2008 13:18

Query Help -
I have a ntext field in Sharepoint database that contains the results of a choice field. There are 5 choices (multiselect allowed) and the results of the choices are stored as ;#General;#Leasing;# ...etc Is there a way to remove the ;# in query at run-time? I am trying to remove those ;# or atleast the # when ... 22 Jul 2008 19:54

Please help with Select Statement (Zip File)
After digging around, I found the source of the problem and I don't know how to fix it. I've recreated my DB and it's in this zip file. The zip file is here and it's really small. http://www5.upload2.net/download/6e8cfbfa2d31009e2afe94e46b67a255/48864815/YAHQQhodIvOktxg/Test.zip I just created 3 little table wi... 23 Jul 2008 10:13

question on indexing
Consider a variation of the classical order header and detail example: CREATE TABLE OrderHeader ( OrderID INT, <- PK OrderNumber VARCHAR(10), <- uniqe (alternate key) CustomerID INT, <- FK ...) CREATE TABLE OrderDetail ( OrderDetailID INT, <- PK OrderID INT, ... 23 Jul 2008 13:18

Manipulating complex joined query in a view
I have a view in a sql server database. This view involves join on project_num with associated with four entities (along with other joins) tblSMI SM prs.dbo.project PR prs.cbo.tblCost C and (SELECT Project_Num, Plant = MIN(Plant) FROM PRS.dbo.Project_Plant PP2 ... 23 Jul 2008 15:22

Dashboard "Missing Index" Report and Resetting Indexes
Is there a DBCC SQLPERF (or other syntax) command to "reset" the indexes that show up in the "Missing Index" report in the Dashboard reports? ... Thanks. ... 22 Jul 2008 16:49

Dashboard "Missing Index" Report and Resetting Indexes
Is there a DBCC SQLPERF (or other syntax) command to "reset" the indexes that show up in the "Missing Index" report in the Dashboard reports? ... Thanks. Sql Server 2005 (Standard) ... 28 Jul 2008 12:04

Database is in Transistion. There is already an open datareader as
There are many ways to list what connections are active on a server. One way is to use sp_who2, and you can use KILL <SPID> to terminate the process. Also, it is possible to set a database to RESTRICTED_USER mode while simultaneously disconnecting all connections and aborting any active transactions. The followi... 22 Jul 2008 16:49

Using single character wildcards in stored procedure and allow
They're supposed to be able to use %, _, and ? in their searches. However, they want to be able to have it do a Begins With without using anything AND be able to use wildcards too. For example, entering 'SMIT' would be the same as SMIT%. I don't see how that would be possible. They should just enter SMIT% i... 22 Jul 2008 17:50