Topics
Started by
Posts
Last post
Hello Everyone I am not able to figure this seemingly very small issue out by myself. I am trying t…
9 replies
Hi Folks, I'm trying to minimize the total number of logical reads against a specific table. I've …
9 replies
Can somone confirm whether it is or is not possible to call cross database functions or procedures …
2 replies
I have a database designed to hold data pulled in from SSIS processing. That DB is then used to ve…
1 replies
I have a table that is a linked list of statuses. I would like to remove unneeded entries from the…
1 replies
Hey, My last question didnt get much help so I thought I would ask a more direct one with less part…
28 replies
Assume that I have two tables one with Clustered index and other table with Non Clustered Index. N…
11 replies
I have a stored procedure that needs to be changed to accept one or more values. These values will…
5 replies
Here is my proc: IF EXISTS (SELECT * FROM sys.sysobjects WHERE name = 'Usp_Col' AND xtype = 'P') BE…
6 replies
Hi, I am running one application and I am populating one database lets say test Database I want to …
7 replies
I have a table Below ... Name DOB MathsScienceChemistyPhysics RAM 11/2/1986 00…
5 replies
I have inherited a very large DB (1.2TB) and am supposed to look for ways to optimize it. Many of t…
2 replies
Hi, I have an existing code in sql server 2000, which after migrating to sql server 2008 the perfor…
19 replies
Hi, in Management Studio you can do for a single index or key the following SCRIPT INDEX AS... DROP…
7 replies
At the moment, my code looks a bit like this: exec dbo.usp_my_stored_proc 1, 12, 10000; exec dbo.u…
2 replies
Viewing 15 topics - 9,676 through 9,690 (of 10,647 total)
You must be logged in to create new topics.