MS Sql Server

July 2004

Active Directory and its impact on SQL Server (and the DBA)
(30 Jul 2004 21:20:54)
Re importing data to oracle9i from Sql server
(30 Jul 2004 20:14:29)
UNIX workstation to connect to SQLServer
(30 Jul 2004 19:10:5)
OLAP Access in SQL Server
(30 Jul 2004 17:54:2)
MS Sql DBA - best book/course
(30 Jul 2004 17:49:41)
transaction log is ~ 50 Meg how do i trunk/comit the log?
(30 Jul 2004 17:45:40)
Client connectivity
(30 Jul 2004 14:25:17)
Update Query with Inner join
(30 Jul 2004 14:24:45)
Re: AWE and Multiple instances
(30 Jul 2004 13:4:10)
LISTOWNER- EMAIL SHIELDING
(30 Jul 2004 13:0:3)
LISTOWNER- Too Many Emails in your inbox?
(30 Jul 2004 13:0:1)
Assign Records to analysts
(30 Jul 2004 12:50:5)
AWE and Mulitpie instances
(30 Jul 2004 6:17:55)
importing data to oracle 9i from Sql sever
(30 Jul 2004 4:45:21)
Retrieve Lost SA password
(30 Jul 2004 4:35:32)
Restore : Only one table ??
(30 Jul 2004 4:30:59)
same temporary table and cursor names running on different DBs and same server
(30 Jul 2004 4:25:59)
Secure Connection
(30 Jul 2004 4:19:8)
Urgent: Regarding use of top
(30 Jul 2004 4:14:53)
Date formatting using convert
(30 Jul 2004 2:14:14)
How to make this query run fast !!!!1
(30 Jul 2004 2:7:13)
How can I avoid Torn pages
(30 Jul 2004 2:0:27)
REVERSE FUNCTION
(29 Jul 2004 15:47:29)
query vs stored procedure performance differences
(29 Jul 2004 8:19:36)
Backup and Recovery case scenarios
(29 Jul 2004 7:46:49)
Re: Spam:RE: Need to replace a funky character
(29 Jul 2004 7:20:23)
Re: MSSQL Scripts[Scanned]
(29 Jul 2004 6:57:11)
MSSQL Scripts
(29 Jul 2004 5:55:44)
Re:Date formatting using convert
(29 Jul 2004 5:47:48)
Re: SQL Server Linked Server problem.
(28 Jul 2004 22:36:14)
DTS Error
(28 Jul 2004 22:30:5)
Need to replace a funky character
(28 Jul 2004 20:53:9)
Stored Proc + Select Statement?
(28 Jul 2004 16:56:51)
sp_attach_db error: correction
(28 Jul 2004 16:46:4)
Default constraints
(28 Jul 2004 16:24:20)
Server Locks
(28 Jul 2004 16:0:30)
Default constraint
(28 Jul 2004 10:58:27)
Moving files around filegroups
(27 Jul 2004 14:18:2)
Changing object ownership
(27 Jul 2004 13:39:55)
Replication with identity columns
(27 Jul 2004 13:34:7)
Re: Database Diagram in Sql Server
(27 Jul 2004 13:21:22)
database backup archive - historical
(27 Jul 2004 10:25:17)
contents of DTS Package
(27 Jul 2004 8:32:8)
DTS faild with 80004005
(26 Jul 2004 21:39:12)
Regarding count and rownum
(26 Jul 2004 15:23:53)
Linked Server
(26 Jul 2004 15:7:50)
test
(26 Jul 2004 10:47:31)
LISTOWNER - LazyDBA paid membership
(24 Jul 2004 23:56:1)
SS Temp tables
(23 Jul 2004 18:33:15)
Import XML file to SQLserver table...
(23 Jul 2004 16:28:57)
SQL 7 Transaction Log
(23 Jul 2004 15:23:13)
server logs?
(23 Jul 2004 15:10:14)
Condition where conditions
(23 Jul 2004 6:54:59)
Utl_file - Invalid Operation
(22 Jul 2004 16:45:35)
DTS Environment Control
(22 Jul 2004 22:52:4)
Re: Spam:RE: Insert Issue
(22 Jul 2004 14:56:3)
Re: Insert Issue[Scanned]
(22 Jul 2004 14:28:2)
Insert Issue
(22 Jul 2004 15:8:29)
Remote Database
(22 Jul 2004 10:17:36)
DROP FUNCTION privileges
(22 Jul 2004 13:11:56)
SQL Query Tuning
(22 Jul 2004 5:28:19)
Shrink, restore lockup EM
(22 Jul 2004 7:28:2)
Re: [Maybe Spam] Unable to detach
(21 Jul 2004 16:1:59)
Unable to detach
(22 Jul 2004 10:16:50)
OSQL Switch to not inclue "rows affected" in output file
(22 Jul 2004 2:30:27)
Indexing
(21 Jul 2004 8:13:27)
Collation problem with foreign key constraint
(20 Jul 2004 7:34:17)
Re: Replicating the permission and login info
(20 Jul 2004 3:24:39)
Replicating the permissions and login info
(20 Jul 2004 2:15:34)
Repeated event error: Login failed for user 'sa'
(19 Jul 2004 22:21:53)
Execute DTS Package from a Stored Procedure..
(20 Jul 2004 1:40:28)
Passwords
(20 Jul 2004 15:23:0)
cannot open database requested in login
(19 Jul 2004 15:10:46)
RESTORE VERIFYONLY
(19 Jul 2004 15:54:40)
Migrate to sql server
(19 Jul 2004 5:47:37)
Outer join in where clause
(19 Jul 2004 12:36:44)
converting to excel format
(18 Jul 2004 5:50:56)
setting password on a database file
(19 Jul 2004 21:12:6)
Re: Itanium
(19 Jul 2004 9:58:46)
SQL Server Agent ?
(16 Jul 2004 20:59:53)
Oracle quickie
(16 Jul 2004 19:13:25)
MSDAORA returns ORA-01476 error
(16 Jul 2004 20:23:56)
Re: DTS for loading text file in Database
(19 Jul 2004 14:24:52)
Restore Time
(19 Jul 2004 2:1:55)
SQLserver 2000 performance with antivirus...
(16 Jul 2004 14:1:26)
row id in ms sql
(16 Jul 2004 15:36:49)
JS Script for creating text report on DB Backups
(15 Jul 2004 20:56:12)
best practices
(15 Jul 2004 23:0:4)
SQLSTATE 01000
(20 Jul 2004 0:27:10)
Best practice
(16 Jul 2004 7:7:28)
Largest Value in a Column
(15 Jul 2004 19:46:34)
Newbie DTS Question
(15 Jul 2004 17:58:49)
History Question
(15 Jul 2004 18:36:31)
permission denied on procedure
(14 Jul 2004 13:25:46)
Windows Longhorn & built in database file system
(15 Jul 2004 14:59:22)
Need help
(14 Jul 2004 15:26:5)
Update Statement
(14 Jul 2004 13:49:20)
How does a DBA determine if a database is really in use?
(13 Jul 2004 19:51:43)
releasing locks
(15 Jul 2004 15:49:55)
Update Query Problem.....
(13 Jul 2004 17:4:9)
Re: Windows Group/SQL Login - not working[Scanned]
(13 Jul 2004 14:13:15)
Windows Group/SQL Login - not working
(13 Jul 2004 14:8:5)
The 'lazy schema validation' option is ignored in this edition of SQL Server
(13 Jul 2004 13:51:14)
DTS To copy text file data in tabl
(14 Jul 2004 1:25:49)
Optimization of Query
(13 Jul 2004 7:8:4)
recursive queries
(13 Jul 2004 6:39:26)
DTS Packet File Name Variables.
(12 Jul 2004 18:45:56)
anybody?? FW: FileGroups and file growth question
(12 Jul 2004 14:27:37)
Size of the database
(12 Jul 2004 9:56:54)
Import from CSV File using SP with bulk insert selected columns
(12 Jul 2004 10:54:23)
Text File Using Stored Procedure
(12 Jul 2004 12:43:12)
Restore sql7.0 database from win2k to win2003
(12 Jul 2004 5:58:1)
Partitions
(12 Jul 2004 5:41:16)
ODBC Problem in Windows XP
(11 Jul 2004 11:10:30)
Problems dropping MSSQL publication
(10 Jul 2004 18:24:0)
REORG JOB AND UPDATE STATISTICS JOB RESULTED IN 20gb GROWTH - WITHOUT DATA GROWTH
(10 Jul 2004 9:30:33)
Companies that uses SQL Server
(12 Jul 2004 19:47:9)
RE SQll Mail
(16 Jul 2004 10:26:20)
database restore issue:
(9 Jul 2004 19:17:7)
MicroSoft Server 7 support.
(9 Jul 2004 14:33:54)
Running jobs in background . . .
(12 Jul 2004 0:7:22)
how to call stored proc from SQL*Plus
(8 Jul 2004 14:7:23)
How to know ?
(8 Jul 2004 4:53:7)
Automating export through SQL Server
(8 Jul 2004 9:16:11)
From Supra PDM to Erwin
(7 Jul 2004 18:11:23)
Table Variables
(7 Jul 2004 16:47:41)
licenses...
(7 Jul 2004 13:46:3)
Simulation of sequence in SQL server
(7 Jul 2004 11:52:45)
Sql Server Restarted
(7 Jul 2004 11:9:54)
How to Reindex and delete torn pages for a table/View
(7 Jul 2004 7:11:46)
Re: SA Access
(7 Jul 2004 7:1:33)
'could not open sqlevn70.rll' Anyone know what causes this error?
(7 Jul 2004 5:28:7)
Dynamic SQL?
(7 Jul 2004 23:30:7)
How to retrieve a deleted table
(7 Jul 2004 6:58:53)
how to call stored procs from SQL*Plus (oracle)
(6 Jul 2004 21:27:21)
CAL for SQL 2000
(6 Jul 2004 18:58:56)
Best order ?
(6 Jul 2004 18:42:7)
SQL Server receiving Faxes( facsimiles) Any suggestions??
(6 Jul 2004 16:38:3)
homemade REPLACE function
(6 Jul 2004 15:29:28)
Binary Data Type
(6 Jul 2004 13:1:32)
How to replace sequence in SQL
(6 Jul 2004 15:26:26)
Porting sql* query to t-sql
(6 Jul 2004 10:14:31)
Job Viewing Permission
(13 Jul 2004 1:59:32)
SQL Mail Problem
(8 Jul 2004 6:12:55)
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=
(6 Jul 2004 17:49:18)
Restore database.
(2 Jul 2004 17:28:4)
Constraint's And UDF's
(2 Jul 2004 16:10:23)
Hex to character conversion
(7 Jul 2004 14:14:38)
See ya next week
(2 Jul 2004 15:52:51)
Starting SQL Server service
(2 Jul 2004 9:35:33)
Help with this code to populate test table
(6 Jul 2004 17:53:42)
"Its just a delete".
(5 Jul 2004 10:24:8)
UNABLE TO CONNECT TO SERVER
(1 Jul 2004 20:47:57)
FileGroups and file growth question
(1 Jul 2004 19:2:54)
Performance Deletions
(6 Jul 2004 19:40:2)
sp_trace
(1 Jul 2004 17:4:2)
Tuning SQLs
(1 Jul 2004 16:45:13)
Migration to Windows 2003, SAN
(1 Jul 2004 15:36:48)
Benchmarking SQL
(1 Jul 2004 16:0:55)
job interviews questions
(1 Jul 2004 0:7:43)
ANSI NULLS AND ANSI WARNINGS
(1 Jul 2004 16:26:20)
Sql Server Fail Over
(1 Jul 2004 15:23:31)
Performance monitoring
(1 Jul 2004 17:16:21)
Execution Plan
(21 Jul 2004 17:57:3)
SQL Mail
(15 Jul 2004 17:44:19)
Query
(18 Jul 2004 3:50:40)
Zip and database backups
(12 Jul 2004 15:23:11)
Replication
(9 Jul 2004 16:56:5)
Question
(21 Jul 2004 9:27:29)
tempdb
(9 Jul 2004 13:59:52)
DTS
(23 Jul 2004 0:10:1)
sql lazydba home page