Viewing 15 posts - 601 through 615 (of 1,478 total)
IIF is an access function that doesn’t exist in SQL Server. You can use the CASE function to check if the phone number begins with 9 and then decide...
--------------------------------------------------------------
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/
May 10, 2010 at 2:59 am
After trigger is executed after the DML operation (insert, update or delete) was executed on the table. Instead of trigger runs Instead of the DML operation that was...
--------------------------------------------------------------
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/
May 10, 2010 at 12:49 am
As far as I know, you can’t define the file group and it will be created on the default file group.
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/
May 2, 2010 at 3:40 am
You can find the answer for your question here – http://blogs.msdn.com/sqlreleaseservices/archive/2008/02/15/end-of-mainstream-support-for-sql-server-2005-sp1-and-sql-server-2000-sp4.aspx
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/
April 29, 2010 at 6:04 am
Notice that I’m using to functions. The first function is GETUTCDATE() that shows the UTC time. The second function is GETDATE() that shows the local time. I...
--------------------------------------------------------------
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/
April 27, 2010 at 8:13 am
You can do it with the dateadd and datediff function. With datediff function you can calculate the difference in minutes between the local time and UTC time. With...
--------------------------------------------------------------
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/
April 27, 2010 at 7:03 am
You are missing an alias to the select statement in the left join. You did use an alias for the openquery function, but you also need to use an...
--------------------------------------------------------------
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/
April 26, 2010 at 7:51 am
I don’t think that DBCC DBReIndex supports working with schemas. DBCC DBReIndex was used in SQL Server versions that didn’t have schemas at all. The schemas were...
--------------------------------------------------------------
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/
April 26, 2010 at 3:44 am
Sorry, I never worked with DB2, so I can't help you with that.
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/
April 21, 2010 at 2:19 am
shen-dest (4/21/2010)
Hi,by joining DMVs and Procedure type objects you may find which SPs has never been executed.
sys.sysobjects-- xtype =P
sys.dm_exec_query_stats --execution_count
dm_exec_sql_text --objectid
Take into consideration that the query plans go...
--------------------------------------------------------------
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/
April 21, 2010 at 1:30 am
constraint that will prevent using any character that is not a digit. Bellow is a demonstration of such a code:
use tempdb
go
--creating the check constraint that limits the values 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/
April 21, 2010 at 1:20 am
I think that you are looking for sp_spaceused. If you’ll run it with a parameter that contains table name, it will give you the (among other things) 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/
April 21, 2010 at 1:02 am
I think that you’ll have to use some third party products such as Lumigent’s Log explorer or Red Gate’s SQL Log Rescue. Another alternative is to create a logging...
--------------------------------------------------------------
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/
April 21, 2010 at 12:56 am
Barkingdog (4/15/2010)
You wrote
>>>
Most chances are that when you added the other column to the index, the index was a covering index. A covering index is an index that 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/
April 15, 2010 at 4:21 am
Most chances are that when you added the other column to the index, the index was a covering index. A covering index is an index that is composed 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/
April 15, 2010 at 12:42 am
Viewing 15 posts - 601 through 615 (of 1,478 total)