Topics
Started by
Posts
Last post
Hi All, I have a procedure that has 5 T-SQL statements to it. These comprise of -- PART 1 -- Inser…
4 replies
I am a developer and not a DBA. My customers are complaining about how slow my application is runni…
5 replies
I have one table here is the DDL Create table dbo.UFM_AGENTS ( TS_ID i…
5 replies
Created a table Create table tmpsize( tmpsizepk int identity, Error_Msg varchar(8000) ) Inserted 5…
5 replies
I have a stored procedure and when I run it First time it creates an execution plan and it takes lo…
13 replies
Hi all, My friend ask me the following transaction problem. Consider the following structure of tab…
3 replies
I have a column of data in a table that I need to update and remove the first 2 characters if they …
11 replies
DECLARE @T TABLE(ID INT,NAME VARCHAR(10)) INSERT INTO @T VALUES(1,'PPP') INSERT INTO @T VALUES(2,'…
60 replies
hi all, while executing the plan Maintenance Plan it's giving error like the log for database 'te…
2 replies
All, I have often worked on the below requirement. There are two tables and fetch the record from T…
5 replies
What can I use to find if a string contains a '? I know how to replace the quote with a blank but I…
15 replies
Hi All I have a query that need to Rewrite it without cursor, function or loop to produce same resu…
4 replies
When an index is created with STATISTICS_NORECOMPUTE = OFF, how frequently is the index updated? I…
2 replies
For a customer, I need to load data from excel 2010 spreadsheets into a sql server 2008 r2 database…
6 replies
I have different groups of items, some items are common in groups. I need a query that can combine …
3 replies
Viewing 15 topics - 4,531 through 4,545 (of 10,647 total)
You must be logged in to create new topics.