Viewing 15 posts - 1,411 through 1,425 (of 1,479 total)
rishgup (10/24/2008)
It might effect. It depends on the rate of the data modification statements. According to the trigger that you posted, all of the triggers are updating 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/
October 24, 2008 at 10:19 am
jennifer_l_hogan (10/24/2008)
It is 7500 rows of data with no unique identifer (I have asked...
--------------------------------------------------------------
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/
October 24, 2008 at 10:12 am
rishgup (10/24/2008)
But my...
--------------------------------------------------------------
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/
October 24, 2008 at 9:57 am
pprajapati (10/24/2008)
I want user is able to create/alter table , view and store procedure...
--------------------------------------------------------------
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/
October 24, 2008 at 9:01 am
I also think that it is a great article. Unfortunately it can’t be mandatory to read it before the first post (as other pointed out even if before first...
--------------------------------------------------------------
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/
October 24, 2008 at 12:13 am
Arul Manoj (10/22/2008)
Actually my table has below structure:
RowNumber UserId UserNmae TimeDifferenceInMinutes
1 ...
--------------------------------------------------------------
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/
October 23, 2008 at 2:59 pm
Arul Manoj (10/22/2008)
I have the below table structure:
RowNumber UserId UserNmae Date
1 ...
--------------------------------------------------------------
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/
October 22, 2008 at 11:40 pm
Just to add on michal's answer. Few months ago Itzik Ben Gun published 2 articles in SQL Server Magazine about derived tables, CTE, table varibels and temporary tables. ...
--------------------------------------------------------------
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/
October 20, 2008 at 5:08 am
GilaMonster (10/20/2008)
Adi Cohn (10/20/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/
October 20, 2008 at 4:53 am
oliver.morris (10/20/2008)
Thanks again.
No I made sure that I did not miss any logs since the full backup. I understand the the veritas backup does do a database backup as well...
--------------------------------------------------------------
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/
October 20, 2008 at 4:15 am
oliver.morris (10/20/2008)
Thanks for your reply. Over the weekend I tried to restore the database, I wanted to restore it to say a couple of hours earlier so I clicked 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/
October 20, 2008 at 4:07 am
Check if the connection attempt made it to the SQL Server or not. You can use profiler to catch failed logins. If there isn’t any failed login when...
--------------------------------------------------------------
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/
October 20, 2008 at 3:32 am
oliver.morris (10/20/2008)
Many Thanks for your help in advance for this. I set up a maintenance plan last week and because its a active database used by about 20 people...
--------------------------------------------------------------
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/
October 20, 2008 at 3:15 am
Sirish (10/17/2008)
(
Empid int,
Employee varchar(20)
)
Create Table #employee1
(
Empid int,
Employee varchar(20)
)
Insert into #Employee values('1','Sirish')
Insert into #Employee values('2','Sateesh')
Declare @Strquery varchar(100)
SET @StrQuery='Select Empid,Employee from #Employee'
EXEC('INSERT INTO #employee1 (Empid,Employee) SELECT ''+@Strquery+''')
Select * from #Employee1
Getting...
--------------------------------------------------------------
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/
October 17, 2008 at 10:04 am
tinku.reddy (10/15/2008)
Actually i detached the database from another server which is sql 2005 and i want to attach it to thesql 200 server.
Can i do that ?
Thank you
No you...
--------------------------------------------------------------
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/
October 15, 2008 at 11:22 pm
Viewing 15 posts - 1,411 through 1,425 (of 1,479 total)