Viewing 15 posts - 1,291 through 1,305 (of 1,479 total)
Just play with it a bit and you'll understand. Bellow is a small script that creates 2 tables and inserts 2 records for each table. All you 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/
December 22, 2008 at 10:31 pm
And happy Hanukkahfor some of us:-)
--------------------------------------------------------------
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/
December 22, 2008 at 1:58 pm
You can do an update with inner join. This way you’ll be able to get the value from the lookup table. In your update statement you should use...
--------------------------------------------------------------
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/
December 22, 2008 at 1:56 pm
One way of doing it is to run a query on all query plans that are in the cache. Here is one version that can be used. Of...
--------------------------------------------------------------
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/
December 22, 2008 at 1:26 pm
GilaMonster (12/22/2008)
subha.v (12/22/2008)
Advanced thaks for all.I didn't expect this much reply from my post. It's really helpful for me to know more about the problem.
If you answered all the questions...
--------------------------------------------------------------
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/
December 22, 2008 at 9:07 am
subha.v (12/22/2008)
It's still running. Nearly 55 min.Thanks
Subha
Any reason that you don't want us to know if you checked for blocking as I asked you before?
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/
December 22, 2008 at 4:33 am
subha.v (12/22/2008)
I have run the query like
Select ColB,ColC from table1 where ColD= 123.
It takes nearly 30 min to finish the execution.
In this table ColD have a non-clustered index. And...
--------------------------------------------------------------
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/
December 22, 2008 at 1:42 am
Mad-Dog (12/21/2008)
I'm talking about backing it up once on creation automatically.THX
Since the trigger is part of the transaction, and you can not backup a database inside a transaction, 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/
December 21, 2008 at 7:00 am
Mad-Dog (12/21/2008)
i don't want to...
--------------------------------------------------------------
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/
December 21, 2008 at 5:33 am
You can do it by running alter database statement. You can look at the script .that I’ve added as an example. Unfortunately you'll have to restart the service....
--------------------------------------------------------------
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/
December 21, 2008 at 4:50 am
I also couldn't find anything to back me up or contradict me, so I decided to do a small test. I created a new database. Altered it to...
--------------------------------------------------------------
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/
December 19, 2008 at 8:13 am
dhanasekar.palani (12/18/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/
December 18, 2008 at 7:59 am
Ninja's_RGR'us (12/18/2008)
There's a question, it's just not obvious.The guy abviously has troubles with the english written language. Nothing to be made fun of guys!!!!!!1
I’m not from an English speaking...
--------------------------------------------------------------
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/
December 18, 2008 at 7:52 am
Is this is your real trigger? Your trigger will send the results of the DBCC INPUTBUFFER to the client, but it won't save the data into a table. ...
--------------------------------------------------------------
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/
December 18, 2008 at 1:05 am
ksprashanths (12/17/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/
December 17, 2008 at 10:17 pm
Viewing 15 posts - 1,291 through 1,305 (of 1,479 total)