MS Sql Server

February 2006

text of an SP
(28 Feb 2006 22:3:17)
need help with format to run and output a file
(28 Feb 2006 21:48:54)
Divide by Zero error
(28 Feb 2006 21:10:55)
Re: Job issue almost working---Damn problem
(28 Feb 2006 19:7:39)
Job issue almost working
(28 Feb 2006 18:38:56)
query required
(28 Feb 2006 10:56:32)
Query Help
(28 Feb 2006 10:54:13)
Confidentiality clauses
(28 Feb 2006 10:26:51)
Re: query required[Scanned]
(28 Feb 2006 9:4:6)
The cursor is READ ONLY
(27 Feb 2006 19:34:7)
tempdb log is very big
(27 Feb 2006 18:2:36)
sort varchar as date/time
(27 Feb 2006 16:51:40)
restore database job 'executing step 1'
(27 Feb 2006 15:50:5)
Re: log shipping[Scanned]
(27 Feb 2006 9:57:26)
Log shipping
(27 Feb 2006 9:53:53)
DATEDIFF - strange behaviour?
(26 Feb 2006 5:42:59)
LISTOWNER- EMAIL SHIELDING
(25 Feb 2006 14:0:2)
To 3GB or not to 3GB ...
(25 Feb 2006 5:25:31)
SQL server: Date difference calculation
(24 Feb 2006 18:38:54)
creating query from two different database.
(24 Feb 2006 16:27:39)
SQL Server DBAs
(24 Feb 2006 16:21:1)
Maximum memory under Windows 2000 server
(24 Feb 2006 15:36:47)
SSIS Package use on SQL 2000 database?
(24 Feb 2006 15:21:3)
multi language---- urgent
(24 Feb 2006 10:19:54)
My first earthquake experience
(24 Feb 2006 9:4:59)
SQLServer Agent question
(23 Feb 2006 21:39:54)
SQL Server 2005 Training
(23 Feb 2006 20:30:46)
Unable to start the SQLServer Agent!
(23 Feb 2006 19:46:28)
SQL 2000 Std and dual processors
(23 Feb 2006 18:58:22)
Script to write query results to db
(23 Feb 2006 15:31:26)
Selecting records and distribute them evenly over a period of time
(23 Feb 2006 15:14:32)
Per pocessor or per seat license..
(23 Feb 2006 14:50:30)
Job issue
(23 Feb 2006 13:50:27)
SQL Server 2005 serial number rejected
(23 Feb 2006 12:15:20)
Pinned tables in memory
(22 Feb 2006 22:46:10)
Suspect on database
(22 Feb 2006 19:32:46)
Theoretical Question about backups
(22 Feb 2006 18:40:2)
script problem
(22 Feb 2006 18:7:20)
SQL Script help
(22 Feb 2006 15:18:47)
Stored Procedure Debugger
(22 Feb 2006 13:4:21)
Script Problem?
(22 Feb 2006 11:8:8)
Trace Output
(22 Feb 2006 5:13:29)
parsing question from a newbie
(21 Feb 2006 21:29:43)
update 1 db with info from another
(21 Feb 2006 20:43:48)
huge trans log
(21 Feb 2006 19:40:1)
Adding a non-clustered Instance to a Clustered Server environment
(21 Feb 2006 16:37:41)
difference between DBCC INDEXDEFRAG and DBCC REINDEX
(21 Feb 2006 15:34:13)
SQL Server DB corruption
(21 Feb 2006 15:8:40)
Query performance mystery
(20 Feb 2006 23:7:58)
Database slowness
(20 Feb 2006 16:1:26)
Summarize Data by week
(20 Feb 2006 14:49:29)
Merge Replication - Few Queries
(20 Feb 2006 9:10:32)
Help with Stored Proceudre
(19 Feb 2006 14:5:50)
Help with removing a character
(18 Feb 2006 1:20:54)
Column Format
(17 Feb 2006 21:5:36)
scheduler error
(17 Feb 2006 20:25:8)
Script for database failure notification
(17 Feb 2006 19:51:57)
Re: [SPAM?] Active Directory
(17 Feb 2006 19:5:11)
Problem with table names in Enterprise Manager.
(17 Feb 2006 18:37:48)
Personal Edition to Enterprise Edition
(17 Feb 2006 18:16:57)
Selecting distinct records
(17 Feb 2006 18:10:48)
Finding those records with only numeric values in a field
(17 Feb 2006 17:35:49)
SSIS Training
(17 Feb 2006 16:32:34)
SQL 2005 x64 - deployment ideas
(17 Feb 2006 15:26:53)
sp3 installed or not
(17 Feb 2006 5:21:57)
Active Directory
(17 Feb 2006 5:18:5)
Analysis Services (2005)
(16 Feb 2006 22:15:25)
Style over substance?
(16 Feb 2006 21:19:37)
Web Query
(16 Feb 2006 19:36:8)
Re Double to Single quotes
(16 Feb 2006 17:47:21)
sql filegroup error
(16 Feb 2006 15:32:19)
need help with update query
(15 Feb 2006 20:44:59)
Performance counters when running 32 bit SS2k on Windows x64
(15 Feb 2006 19:12:31)
Clustering
(15 Feb 2006 17:33:45)
Disable Triggers in "session"
(15 Feb 2006 16:43:59)
SQL Server Configuration
(15 Feb 2006 14:28:44)
txt file insertion into table
(15 Feb 2006 13:59:21)
parsing in tsql
(14 Feb 2006 23:53:37)
SQL 2000 64 bit on em64t processors
(14 Feb 2006 22:33:6)
Using OLE DB with BLOBs and BULK operation
(14 Feb 2006 21:23:30)
Corrupted SQLDUMP0001
(14 Feb 2006 19:16:21)
Bulk Insert - Failure to properly insert 'real' data type field (SQLFLT4)
(14 Feb 2006 17:48:22)
MS sql 2005 entprise server on a cluster MSDTC slow
(14 Feb 2006 17:42:36)
.net dll for extended stored procedure in SQL 2000
(14 Feb 2006 17:37:35)
Help with sort in a Union (odd, but needed)
(14 Feb 2006 16:23:17)
Optimization Job which re-ndexes
(14 Feb 2006 16:19:32)
Re Compatibility level in SQL
(14 Feb 2006 16:13:36)
Temporal Difficulty
(14 Feb 2006 16:12:22)
Re: indexed view newbie[Scanned]
(13 Feb 2006 21:39:15)
set value = to aggregate
(13 Feb 2006 21:8:13)
How to reverse out of concatenation in SQL Server...
(13 Feb 2006 19:12:21)
Recommendation for 3rd party SQL Server encryption programs?
(13 Feb 2006 18:56:4)
PAE, AWE and Memory
(13 Feb 2006 17:53:34)
how to store multiple variables thru 1 select statement
(13 Feb 2006 17:10:59)
Reading XLS data to SQL Server table
(13 Feb 2006 7:22:9)
SAP - APPS SERVER ... WHAT IS ...
(12 Feb 2006 23:1:10)
mssql restore error
(10 Feb 2006 21:35:39)
Re: Sql Server Service status is 'starting'
(9 Feb 2006 19:26:7)
indexed view newbie
(9 Feb 2006 18:47:10)
real-time database?
(8 Feb 2006 19:35:41)
Return of monthly sales
(8 Feb 2006 19:0:9)
Backup Database
(8 Feb 2006 16:55:13)
Re Migrating SQL 7 to 2000
(8 Feb 2006 11:28:8)
Re: [SPAM] - Re: Backup SQL 7.0 database, Restore on SQL 2000 - Number of numbers in MIME From exceeds maximum threshold
(8 Feb 2006 10:3:9)
tempdb filling up
(7 Feb 2006 23:32:50)
Backup SQL 7.0 database, Restore on SQL 2000
(7 Feb 2006 22:43:59)
tempdb problem
(7 Feb 2006 21:57:37)
Error Log Message
(7 Feb 2006 19:6:43)
Re: [Possible Spam] Error Log Message
(7 Feb 2006 19:5:52)
create a new sql 2000 database
(7 Feb 2006 18:29:13)
reattach sql 2000 database
(7 Feb 2006 16:11:33)
Dyanmic column name
(7 Feb 2006 15:34:45)
T-SQL question when the data exceeds column length
(7 Feb 2006 15:27:25)
Performance Question
(7 Feb 2006 15:26:43)
Problems if all Reporting Services components on one server?
(7 Feb 2006 15:16:20)
Searching/Extracting numerical data
(7 Feb 2006 15:10:32)
SQL Syntax on summarization
(7 Feb 2006 14:50:22)
Re: IF exists DROP
(7 Feb 2006 14:45:52)
MS SQL Server CE/Mobile Edition.
(7 Feb 2006 0:1:53)
Update change tracking
(6 Feb 2006 21:33:44)
Enterprise Manager vs. SQL Server Management Studio Express
(6 Feb 2006 17:37:21)
help with trigger
(6 Feb 2006 17:10:40)
Re: [Possible Spam] T-SQL Question
(6 Feb 2006 16:52:57)
Re: T-SQL question
(6 Feb 2006 16:52:3)
SQL Server 2005 Code (Row Numbers)
(6 Feb 2006 16:51:38)
Having trouble running SQL / Agent under Local System ...
(3 Feb 2006 22:35:23)
BIG Delete question
(3 Feb 2006 20:15:33)
Missing a convert parameter...
(3 Feb 2006 20:14:11)
Master job server
(3 Feb 2006 10:11:0)
SQL error - optimized 8 concurrent queries
(2 Feb 2006 21:49:14)
SQL SERVER - SAN vs NAS
(2 Feb 2006 20:19:47)
time out waiting for memory resource
(2 Feb 2006 19:37:16)
Another Get RID OF DUPs Question
(2 Feb 2006 18:20:59)
Errors returned by SQL Server
(2 Feb 2006 17:50:42)
Email Working ?
(2 Feb 2006 16:28:40)
backup over server
(1 Feb 2006 13:7:13)
Central Instance Monitoring for SQL Server 2005
(1 Feb 2006 13:4:48)
Stuck
(1 Feb 2006 9:4:26)
Linked Server to text problem
(1 Feb 2006 2:45:40)
sql lazydba home page