Viewing 15 posts - 1,381 through 1,395 (of 1,478 total)
SQL Reddy (11/15/2008)
--------------------------------------------------------------
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 15, 2008 at 4:24 am
binu.ma (11/14/2008)
HiThanks for the reply.I need to confirm one more thing.Where I can restore 3 pm full backup and 4 pm tlog backup .
Maybe. If you took...
--------------------------------------------------------------
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 14, 2008 at 9:27 am
amitgupta.gec (11/11/2008)
Declare @RestoreFile varchar(255)
Set @RestoreFile='D:\Sql backup\Diff_'+ CONVERT(varchar, CURRENT_TIMESTAMP, 112) + '.BAK'
alter database dbname set offline with rollback immediate
RESTORE FILELISTONLY FROM DISK=@RestoreFile
RESTORE DATABASE dbname
FROM DISK=@RestoreFile
WITH
MOVE 'dbname _Data' TO 'D:\Sql...
--------------------------------------------------------------
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 11, 2008 at 6:41 am
SqlUser (11/11/2008)
1 Ok ...
--------------------------------------------------------------
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 11, 2008 at 4:26 am
Most chances are that your data recovery model is set to full, but you don't have any log backup. I reccomend that you'll read in Books On Line about...
--------------------------------------------------------------
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 11, 2008 at 12:41 am
Kishore.P (11/10/2008)
CREATE PROCEDURE dbo.cte_test( @CustomerNumber Int)
AS
BEGIN
if (@CustomerNumber = 100 or @CustomerNumber > 0)
...
--------------------------------------------------------------
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 10, 2008 at 7:18 am
Smartdog (11/10/2008)
i just have one question, what is difference between row trigger and tabl trigger, and what...
--------------------------------------------------------------
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 10, 2008 at 1:08 am
iqtedar (11/9/2008)
--------------------------------------------------------------
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 9, 2008 at 1:49 pm
Smartdog (11/9/2008)
um updating a record in a row in the table summary by adding the number of rows the been updated into the existing number
let for...
--------------------------------------------------------------
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 9, 2008 at 1:44 pm
Notice that in the update statement I'm joining summery table to inserted views. This should make should update all the records in summery table, that were also updated in...
--------------------------------------------------------------
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 9, 2008 at 7:13 am
Smartdog (11/9/2008)
/****** Object: Table [dbo].[Memo_Tasks] Script Date: 11/09/2008 14:49:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Memo_Tasks](
[task_no] [int] IDENTITY(1,1) NOT NULL,
[memo_code] [nvarchar](10) COLLATE Arabic_CI_AS NULL,
[memo_title]...
--------------------------------------------------------------
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 9, 2008 at 6:20 am
Smartdog (11/9/2008)
--------------------------------------------------------------
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 9, 2008 at 5:26 am
iqtedar (11/8/2008)
i have a question regarding assigning permission to the user..i did try searching the forum but didnt find anything..i know this place 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 9, 2008 at 5:19 am
I'm sorry but it isn't possible. Don't you have a backup to restore?
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 5, 2008 at 11:00 pm
One more option is to use a third party tool that knows how to backup and compress that backup file. There are few tools that can do that...
--------------------------------------------------------------
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 5, 2008 at 5:03 am
Viewing 15 posts - 1,381 through 1,395 (of 1,478 total)