Topics
Started by
Posts
Last post
Hi, I have a table with about 466 Million rows. In this table there is a int column called WeeksTo…
19 replies
Ok I am writing an automated process that moves a database to a link server and restores it. This c…
8 replies
I have below table: IF OBJECT_ID('tempdb..#complaints') IS NOt NULL DROP TABLe #complaints --===== …
11 replies
i have created NONCLUSTERED index on table but my report is taking more time that's why i created c…
1 replies
I have this simple select query in a proc and the query is taking approx. 30 seconds to return appr…
5 replies
Hi, I am writing a trigger for getting values to auditlog table when the values gets updated. Below…
1 replies
My data looks like this: I need to calculate the last two columns (noofgrp and grpsize) No of Group…
10 replies
Hi All, Please consider the below script DROP TABLE #TA DROP TABLE #TB CREATE TABLE #TA (Id int,Ch…
3 replies
I have a below table: --===== If the test table already exists, drop it IF OBJECT_ID('tempdb..…
16 replies
I would like to get the size of the tables in my database BUT as follows: SIZE OF (SELECT * FROM my…
2 replies
I have this code: ------------------------------------------- Declare @sql as varchar(4000) declar…
15 replies
I have a WHERE clause in a DELETE statement and the x.[Timestamp] field is the PK: DELETE x …
4 replies
Hi, I have a procedure which inside I call two other Procedures, the first one is updating table Pu…
22 replies
Hi guys Banging my head off the wall with this one. I have redeveloped a stored proc which generate…
8 replies
I need some help on looping through each row of Table valued parameter. I have user defined type CR…
4 replies
Viewing 15 topics - 3,076 through 3,090 (of 4,984 total)
You must be logged in to create new topics.