Viewing 15 posts - 1,366 through 1,380 (of 1,479 total)
You can do backup and restore and then run delete statements according to your criteria. Another option is go generate the scripts, run the scripts and then import the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 5:07 am
Beside connection pooling it could also be a situation that a user has few connections. He closed one of them, but still has other open connections and those are...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 4:26 am
pratyush.singh.chandra (11/19/2008)
EXEC master..xp_cmdshell 'bcp "SELECT * FROM persondb..[company]" queryout d:\mushi.txt"" -U sa -P -c...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 4:22 am
This is one of the cases that you can do a very quick test to find out how it works instead of taking the word of me or anyone else:-)....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 2:35 am
One more option is to use OSQL (from command line or from SQL Server with xp_cmdshell).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 2:27 am
The code bellow will update the records that you wanted to with you example, but I’m not sure that it is what you want. In your explanation, you wrote...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 1:22 am
Chris Morton (11/19/2008)
i have this sp:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:????????
-- Create date:
-- Description:????
-- =============================================
CREATE PROCEDURE LrandomiseData --'cALLDISPOSITION', 'CALLDISPOSITIONID', NULL, null
...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2008 at 1:04 am
Thank you for notifying me. Just fixed it.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2008 at 10:54 pm
You showed us only part of the code. You need to show us all the relent code. Since you mentioned in your message that you worked with stored...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2008 at 9:59 am
You can use case statement to check the amount of days that passed and then use the same case statement in the group by clause. Here is an example:
--creating...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2008 at 7:43 am
arup_kc (11/18/2008)
Hi kshitij and John,I have heard that 2GB is the size limitation of table variable, later it crushes.
Is it true?
Thanks in advance.
AFAIK there is no such limit to a...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 18, 2008 at 6:50 am
Not with SQL Server 2005. You can create an indexed view on the table that will have a unique constraint and will not include NULL value, but I have...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2008 at 12:16 am
The automatic failover is very important different. Beside that there are other differences. Log shipping is always asynchrony. Mirroring can be synchrony or asynchrony. You can...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 16, 2008 at 11:31 pm
SQL Server locks and unlocks the records for you, so you don’t really have to do it in your code. The subject of locking is to long and complicated...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 16, 2008 at 11:23 pm
Mani (11/16/2008)
Iam running the above stored procedure as job from sqlagent. The job history shows the job was success and has no errors, eventhough the msdb database not backedup!
why its...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 16, 2008 at 2:25 am
Viewing 15 posts - 1,366 through 1,380 (of 1,479 total)