Viewing 15 posts - 526 through 540 (of 1,478 total)
I would still check for the set options. Bellow there is a code that shows you what can happen when you use different set options at the procedure’s 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 15, 2010 at 8:55 am
Since you didn't show us the table and proc's code, I can only assume that something like the code bellow would work
select min(status) from...
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 9, 2010 at 9:57 am
I think that in this type of question it is better to test it for yourself. It will be much faster then waiting for an answer, and there is...
--------------------------------------------------------------
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 31, 2010 at 10:15 am
Make sure that the login is not also a member of sysadmin server role. If a login is part of the sysadmin role, then it’s permissions are not being...
--------------------------------------------------------------
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 28, 2010 at 7:49 am
If we know that a car can have only one owner and it can’t have more then one owner, then I’d go with a foreign key like you suggested. ...
--------------------------------------------------------------
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 28, 2010 at 7:42 am
ps. (10/27/2010)
Hi Gail. I am confused a bit. see these links.http://stackoverflow.com/questions/418082/sql-server-2005-generated-create-table-script-not-working
http://dbaspot.com/forums/sqlserver-server/375200-create-table-script.html
IN both of the cases users are creating tables with these settings. Am i missing something?
I think that this...
--------------------------------------------------------------
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 27, 2010 at 10:11 am
If you work with SQL Server 2000, my answer won’t work for you. Next time pleas give us more information. I suggest that you’ll fallow the link...
--------------------------------------------------------------
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 27, 2010 at 9:59 am
I’m not aware of such setting in the database or server level. I know that you can prevent page level lock on index and table level when you create...
--------------------------------------------------------------
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 27, 2010 at 8:34 am
A process that is killed and is doing a rollback cannot be killed again. You’ll have to wait until it will finish the rollback. By the way,...
--------------------------------------------------------------
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 25, 2010 at 2:46 am
Actually it has nothing to do with the edition that you work with. This procedure was needed in older version of SQL Server. If I’m not mistaken it...
--------------------------------------------------------------
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 14, 2010 at 9:27 am
Doesn’t DBCC FREESYSTEMCACHE clear only the memory structures? Are you sure that it shrinks the tempdb?. I don’t have here SQL Server 2000 to test it, but...
--------------------------------------------------------------
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 14, 2010 at 6:54 am
There is a KB article about it - http://support.microsoft.com/kb/906344/en-us
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/
October 12, 2010 at 10:50 am
You need to specify the column's name after the first condition
select * from mitmas where mmitno like '%655599972D7%' or mmitno like '%655599989D7%'
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/
October 12, 2010 at 10:46 am
I have to agree with Ninja's_RGR'us. Assuming that the column primaryKeyID is indeed the primary key, this statement should run very fast with row level lock and shouldn’t cause...
--------------------------------------------------------------
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 12, 2010 at 10:43 am
You can script any job and check the script to see how to schedule a job or read in BOL about sp_add_jobschedule
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/
October 8, 2010 at 8:31 am
Viewing 15 posts - 526 through 540 (of 1,478 total)