Topics
Started by
Posts
Last post
Hello All, I have been searching about the TSQL Transactions. I ll give a code example: BEGIN TRAN…
3 replies
Can any one tell me, How can i trace which user are alter the database table, sp,Trigger. else ho…
1 replies
Hi The below query is invoked by apps. SELECT TOP 100 S.*, STA.VALUE STATUS_DESC FROM MSGS MG (NOLO…
6 replies
Hi All, I need your people guidance to create the indexes for an existing table which is used in pr…
21 replies
I cannot figure why this query statement is unacceptable in my SPROC. Here's the message when execu…
3 replies
I have a inventory table which contains data of around 3000 inventory and their price for each day.…
22 replies
Hello all, I am using a 3rd party application which has been running very poorly. I have run a few …
6 replies
Using the DBCC SHOWCONTIG ('TABLENAME') My book states that If the Optional Name or ID of the index…
5 replies
Hi, I want to generate a report at the end of the month to see what all activities have been perfor…
6 replies
Hi, We have this table {uniqueid, userid, reportname}. A user can have more than one reportname. Th…
6 replies
Hi, I want to write a stored procedure in SQL Server that gets two parameters and makes a query bas…
5 replies
Can someone see what else can be done to optimize this script? It is taking almost 2 minute to ret…
16 replies
I have posted before on this idea, to be able to find those views/tables which have not been used i…
2 replies
hi all, I have a table as ID Field Value == ======== ====== 1 UserNa…
1 replies
Hi Guys, What are the steps I need to check before host the database into the new cluster environme…
1 replies
Viewing 15 topics - 1,891 through 1,905 (of 17,082 total)
You must be logged in to create new topics.