In a previous job interview, I recall the hiring manager asking me what I thought of Oracle (I was applying for the SQL Server DBA position). So I would like to know what is your take on Oracle? As in compares to SQL Server. Pros and cons of Oracle? Difference(s) between Oracle and SQL Server? […]
2001-11-14
11 reads
Hello all, I have created a DTS package that uses the FileSystemObject option to check for a file. However, it fails everytime regardless if the file exists or not. Is this the best way to automate checking for a file? If so, what could be causing this to fail when the file exists? Jason BTW […]
2001-11-12
1 reads
I am trying to limit the number of indexes in a database but don't know a way to determine if they are ever used. What is the best way to determine if an index is used?
2001-11-08
I was under the impression that you could have 32767 users in database but I cannot create more than 16379 users. Looking at the system proc sp_grantdbaccess, near the end of the code we see: -- OBTAIN NEW UID (RESERVE 1-4) -- if user_name(5) IS NULL select @uid = 5 else select @uid = min(uid)+1 […]
2001-11-08
8 reads
We have Win2K Advanced, SQL 2K Enterprise setup in a cluster and failover would work flawless between Node A and B without a problem. Did testing with it for about 3 hours without any problems. After installing SP1 for SQL2k and rebooted both servers, we can failover to Node B, but can't fail back to […]
2001-11-08
3 reads
Is it possible to recreate database files from a backup file as *detached* database files? Bengt
2001-11-07
is it possible for my asp scripts hosted on a external IIS to establish a connection with the sql server sitting in my intranet? can i "open" a particular db to that external webserver?
2001-11-07
2 reads
is it possible for my asp scripts hosted on a external IIS to establish a connection with the sql server sitting in my intranet? can i "open" a particular db to that external webserver?
2001-11-07
Is there a way to get a SQL Server to answer more than one port? I have a client that has three servers. They only have one ip address exposed to the firewall. Currently, I have set up a NAT translation that maps our external ip address using port 1433 to one of the servers. […]
2001-11-07
149 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers