170 reputation
8
bio website
location
age
visits member for 2 years, 4 months
seen 11 hours ago

Jul
25
comment Splitting a large SQL Server MDF file
I can't think of a time that you would ever want to use a RAID 0 for a production database server. One RAID issue and you lost everything.
Jul
11
comment What is the most effective way to compress and store a SQL Server backup?
If you compressed your backups via SQL compression, you won't be able to get much compression if you attempt to zip/7zip/rar the backup file.
Jun
13
comment LDAP in SQL Server 2012
The problem isn't setting up a linked server but querying the LDAP which uses the Active Directory Helper Service
May
3
comment What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
CI - Insensitive AS - Accent Sensitive
Apr
4
comment Role of Database Administrators
DBA should be responsible for DDL. You will end up with a mess if you let the developers have that role!
Jan
23
comment How to delete and create user remotely on SQL Server 2000
More like 150+. We already have 22 converted to 2008R2. The size really won't be much different than our warehouse
Jan
18
comment Bulk insert into SQL Server from VMWare guest using distributed switch
Is VM showing any errors?
Jan
18
comment How to delete and create user remotely on SQL Server 2000
I posted on FB that maybe I need to consider writing some code in case of zombie attack just to cover all bases! All of this is because someone ran a job during business hours after I told them not to do that and messed up some data.
Jan
17
comment How to delete and create user remotely on SQL Server 2000
Revoking access deletes the user. Revoking login is only for windows accounts but that did give me another idea - change the users rights
Jan
17
comment How to delete and create user remotely on SQL Server 2000
Yes, just to ensure that the person at the remote location can't access the database during this process. Not the login but just the user
Jan
17
comment What is the difference between a “record” and a “row” in SQL Server?
I once asked a question in MS forum many years ago in the wee hours of the morning after working on a problem for a long time and accidentally mentioned the word 'record' and yeah, he jumped on me for that one. Now I have a problem with all of the development team calling it record, just to see me wince.
Dec
10
comment MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
Another strange development. I attempted to run subinacl to adjust the permission levels - access denied even running as administrator on the server
Dec
7
comment MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
abort request issued to transaction child node or parent node. The actual error message is deep in the MSDTC logs that need to be translated using tracefmt
Nov
15
comment Is it useful to have the SQL Server instance root directory on a separate drive?
Plus, separating a drive into two or more partitions won't really help disk I/O. But yes, I totally agree with you. It makes things look so much nicer to put the database files in the root of the drive and it makes it easier to spot things. I usually put everything into directories like D:\Data E:\Logs F:\Backup ,...
Oct
5
comment Slow backup and extremely slow restores
I created a linked server and copied the data in. Then I scripted out the indexes in MS-SQL
Sep
13
comment Options for keeping two SQL Server Compact databases in sync?
If you have another SQL server, you could use merge replication to synchronize the data using web synchronization. The two compact editions would be the subscriber and the regular SQL server would be the publisher