index
> SQL Server Database Engine
SQL Server Database Engine
SQL 2005 and LDF files. Are the following command acceptable and sufficient?
I want to lock mdf file.
Long backup and unexpected database size
Setting up memory for SQL 2008 AWE and SQL 2008 x64 Advice and Recomendation
nvarchar(max) or nvarchar(2048)
SQL Server 2005 Workgroup - Performance counter shared memory setup failed
SQL Database Connectivity using C Sharp
PUBLIC role is missing in SQL Server 2005
Help! - sql server service stuck in "stopping" state
index fragmentation and maintenance paln
What happens if we truncate a log file
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path
sql server ...fragmentation after data deletion
VAS Memory Fragmented
TempDB Contention
open cursors on server using "dbcc cursorstats" cant figure out whats causing it
foreign key and null values
Any way to re-create ##MS_AgentSigningCertificate## user in master database
Information From DBAs - For Database Developer (SQL Server 2005)
No Description - Modify Backup Maintenance Plan failes to save.
64 bit sql server - out of control
Prevent SELECT * query
reset fill factor back to server default
Columnar Database/Vertical database
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent
Error Occured while attaching the DataBase
Connection Error: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.
100% CPU - SQL Server 2005 Standard Edition
Upgraded to SQL Server 2005. Updates no longer work. Error "Could not find server 'DEVDB' in sysservers. Execute sp_addlinkedse"
A new connection was rejected because the maximum number of connections on session ID
Recurring error - The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors.
Attach a Database that lost filestream folder
Table partitioning and performance
HierarchyID is VERY SLOW sometimes, looking for suggestions
Indexing Columns
Index Scan or Index seek
SQL Server Service found in stop state unexpectedly
how to activate/instal sqlserver agent in sqlserver 2008
Async_Network_IO wait type 50% of wait times
Errors connecting to SQL Server 2005
Reorganize online Sql server standard edition 2005 (64-bit)
DROP TRIGGER BETWEEN SQL EXPRESS 2005
what is the root cause?
Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.).
SQL Server is not starting
SA Password change doesn't 'take' on SQL 2000!?
when was a index last rebuilt in sql 2000
ADO Vs ADO.Net
Failed to initialize MSDB database for tuning (exit code: -1073741819). (DTAClient)
Getting Connection Information
Maintenance plan for DB backup failed with the error : 64(The specified network name is no longer available.).
creating a clustered index
Agent won't start after installing german language packages
SQL Server Active Active Failover Cluster w/ transaction Replication, Registry Resource will not hold SQL Server Parameter Values
Duration, starttime and Endtime in profiler...
Filter date on a view
Filegroup Backup/Restore in sql server 2008
Assigning specific processors to SQL Server instances, good or bad idea?
help in line of cmd file
Threads
5,982
1
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
next
last
Home
Copyright 2009-2010 by sqldev.org All rights reserved