Need to understand if SQL Agent goes through AD Domian Controller in order to authenticate to the same sql server. Both run under the same nt...
while installing cluster, there's a Cluster Network Group dialog that pops up and wants you to provide public and private ips. When you provide the...
In my testing I have filled up the tempdb multiple times, and was expecting to get "Could not allocate space for object..." once. Instead I am...
Wanted to see if anyone had an issue installing both SQL 2008 MS and SQL 2000 EM on the same box. is there a conflict? Thanks
Hi all, I need to query on Filegroup free space rather than just a file free space. So, say I have a filegroup with 3 files, and need to know when...
Hi all, How can I check if the Service Broker is enabled for a database or a server?
This service used to be used in SQL 2000, is it discontinued for SQL 2005 ? The service doesn't exist on SQL 2005 boxes.
Does anyone know of a good book on Advanced Monitoring of SQL Server. I don't mean just your basic book on basic counters, but something more...
I have a feelining that I will not be able to isntall multiple instances of SQL on the same san drive, because it can only be owned by one group at a...
Please remind me, on sql 2005 where do I look for the error output in the Agent Job. Like we have Advanced tab in SQL 2000 we can write out a txt...
I understand that if there's a clustered index, there won't be any RowID, because we can find the row based on clustered index. So, since there's no...
In sql 2000 when I need to find out which stored procs a specific user has EXEC permissions on, I simply click the nifty Permissions button in the...
Sometimes when trying to get to database Properties I get an SMO error: Property Owner is not available for Database…. This property may not exist...
Is there a way to search on specific Duration thresholds, such as >1000 in a trace file? I know you can filter to initially trace on specific...
Hi, I've often wondered what would happen if one node in a cluster eally died, and I'd have to rebuild it from scratch, OS and all. Whould I then...
In the Progfiler, All the ...:Completed tasks is what I mostly uee for tuning, such as RPC:Completed and so on.<br /><br />Will the statement still...
Hi all, From a developer's point of view, what would be a prefered method of connecting to a Failover Partner database: 1. Include it in initial...
Some DBAs are insisting that VARCHAR is a no-no for small columns, while others say it matters not. Whanted to hear some opinions on that, what are...
Hello all, I collected a perfmon log file, which I was able to start fine, and it actually has data in it, 15 mb of data. But when I load it into...
Hi, Which system table can I look in to see if the databases are in Full recovery Mode. Basically, I want to quickly view all the databases on the...
Separate names with a comma.
