If a decimal point or commas are allowed, add the negation for these values

"All numbers" is logically equivalent to a double negative of "NOT ( any non-numbers )", so just...

"All numbers" is logically equivalent to a double negative of "NOT ( any non-numbers )", so just use

Column NOT LIKE '%[^0-9]%' -- the caret ( ^ ) means NOT...

The schema uses the design pattern named "Adjacency List" and needs to be converted with a recursive CTE to a "Path Enumeration" pattern before converting to XML.

With IndustryCodes_Path

([IndustryCode],[IdIndustry], LevelCnt, [IndustryName],...

There is no easy way and you will need to generate script for drops and create of primary key, unique and foreign keys:

ALTER TABLE [<owner_name>].[<table name>] drop <foreign key constraint...

My day to day is administering the servers, looking after security, tuning queries, releases, security changes, putting new jobs in place, maintenance, replication upkeep and so on and so forth....

The SQL Server Customer Advisory Team has a white paper "Using Replication for High Availability and Disaster Recovery in SQL Server 2008." at http://sqlcat.com/whitepapers/archive/2009/09/23/using-replication-for-high-availability-and-disaster-recovery.aspx

On page 39, you can see that...

Have you checked the transaction log for a large number of Virtual Log Files by running dbcc loginfo() ? A large number of VLFs will cause slow SQL Server...

Big warning !! Discover this when someone setup a "shrink tempdb" job and errors would then occur.

If you run DBCC SHRINKDATABASE, no other activity can be occurring within the...

Found a long info knowledge based article titled "How to reduce paging of buffer pool memory in the 64-bit version of SQL Server" that appears to apply. http://support.microsoft.com/kb/918483

The article has...

In order to do this efficiently, we would want to use the Cluster name/SQL Instance name as we will never know which SQL Instance/server is up and active if we...

"The columns in "tbl_faculty" do not match an existing primary key or UNIQUE constraint"

The error message with SQL Server 2008 is a little clearer :

Msg 1776, Level 16, State 0,...

regarding SQL Server Memory Usage on a 64-Bit Platform, I have had the same experience as Jeffrey and

Lynn. For reference:

The 64-bit platform allows SQL Server to use much...

Please also check this blog about SQL Server being paged out due to the file system cache size and how to trim.

"A significant part of sql server process memory has...

What does perfmon show for "PagingFile:%Usage" ?

What are the SQL Server memory settings ? You can get the setting by running:

exec sp_configure 'min server memory (MB)'

exec sp_configure 'max...

Try this :

SELECT A_typemaintest.symbol

, A_typemaintest.mftp_type

, A_typemaintest.RowNumber

...