Topics
Started by
Posts
Last post
I have the below table. Rulesid functiontypeid name nickname nametype 1 …
1 replies
Hi Friends, Yesterday we had a deadlock in one of our application which was running on mysql (Live …
6 replies
I have a table defined as: create table test (a char(3)) If I populate 1 row with the empty string …
13 replies
Hi All, I am executing delete statement in production server and its taking more time . can any one…
5 replies
I have the following code: SELECT dbo.fn_Get_Week_By_Date(DDATE) AS Week, PRODUCT_CODE_CREW_MEMB…
5 replies
i need any alternative for select last_user_seek,last_user_scan,last_user_lookup from sys.dm_db_in…
4 replies
how do you make a parameter in an update sp optional I am trying to make a general update sp for a …
2 replies
I have a table T with columns A,B,C & D as below: A, B, C, D A1,B1,USD,LIBOR A1,B2,JPY,FIX…
10 replies
Hi All, I have a question ,Is parsing xml leads to performance hit? If yes ,please provide with rea…
1 replies
Hey Guys Basic Background: LineUp Table contains a transaction, which is split up into n-amount of …
5 replies
Hi, When I am trying to run the below procedure, and at the same time if other user is also accessi…
1 replies
hi, I have two tables like create table a(id int, expense int) insert into a select 1,2000 union a…
4 replies
I have a server on sql server 2005 sp3 running a query/stored procedure intensive application. They…
6 replies
Hi, Is there any way to write text to a text file inside storeproc besides using any DTS/CLR native…
1 replies
Hello, I'm working on a database which has a table with an xml column. I'm not able to query the co…
3 replies
Viewing 15 topics - 916 through 930 (of 4,155 total)
You must be logged in to create new topics.