|
Content with label server in Tech Stuff (See content from all spaces)
Related Labels:
sql, 2005, storage, performance, alter, table, columns, full, text, indexing, usb, nas, network, attached, express, attach, database
SQL Server 2005
All our SQL server related topics: regular expressions in sql server 2005 http://msdn.microsoft.com/msdnmag/issues/07/02/SQLRegex/default.aspx performance issues with sql server 2005 http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/perf/defa ult.mspx?mfr ...
Other labels:
2005
|
SQL Server Express after database is attached, it says In Recovery
Google searches: "sql server express" "attach DB" "in recovery" No documents "sql server" "in recovery" Can be caused on Windows Vista with SQL Server Express when the directory the database files are in does not have sufficient permissions. Related: http://forums.microsoft.com ...
Other labels:
sql, express, attach, database
|
SQL Server Speed Test Performance Network Attached Storage Vs. External USB Hard Drive
I was surprised to find the NAS performed as well for display of a large table from this database as the WD USB drive! Perhaps the table display in SQL Management Studio was mostly CPU or memory bound. It's difficult to get Sql Server 2005 to run ...
Other labels:
storage, sql, performance, 2005, usb, nas, network, attached
|
How To Enable SQL Full Text Indexing
FullText Indexing" is grayed out it means that fulltext indexing is not enabled. Step 1 Enable Full Text Indexing for the TheDatabase database This query will tell if FTS is enabled: SELECT DATABASEPROPERTY('TheDatabase','IsFulltextEnabled') If you get a one, FTS is already enabled ...
Other labels:
sql, 2005, full, text, indexing
|
Adding Column After Another Column - SQL Server 2005
short answer: Sorry, not possible without moving data to a temp table. Explanation: There are at least two ways to add new columns to a table in SQL server: It is possible to use the ALTER TABLE sql query to add a new column Use the Microsoft ...
Other labels:
sql, 2005, alter, table, columns
|
|
|
Browse Space
