I measure on a test server. I do not restore between tests (why?). There is no workload on the server. Measurement is consistent in every run I try....
I am performing my query from SQL Server Query Analyzer. I will try what you are proposing but why would it be faster? My search condition is not...
I am not sure I understand your last paragraph. In any case there is definately a big difference. Here is the trigger. I do NOT update any of the two...
Hi pros, I have an update statement that updates about 14 million records. It involves a few joins and finally updates 1 sigle column in the target...
quote:Originally posted by MohammedU There is no choice of adding additional disk then you want to create partition on the same disk....
Hello guys, What is your opinion on the following: 1) I have a rather large table (for my definition of large). Approx 5 million rows 2) There is...
thanks guys. Clever solution. I only have small tables to work with so performance should not be a problem KKT
What would the implementation look like? Something like a loop in all rows of the same group? I cannot imagine how to imlement something like that....
Hi all, has anyone ever come to a solution in joining strings together in a comma separated fashion? Something like an aggregate e.g. SELECT X,...
quote:Originally posted by Adriaan Could it be that the SQL Server service is running under a local administrator account? Yea it is the default...
Well, I could change the location of all the database files as I am waiting for a new clean disk. I can move everything in there. It should not be a...
The DB_DATAWRITER approach does not allow users to create databases (this means a lot of incoming phone calls for me) and the other approach with the...
Hi, Adrian, this doesn't seem to work. Being a system administrator in sql server allows you to create a database anywhere you like, although at the...
Yes I know it is not a good idea to have a guid as a clustered primary key. But do you think that this relates to my initial question? KKT
Does the column just happen to be called GUID?<br /><br />>> It is actually called GID. It is of type uniqueidentifier.<br /><br />Does the...
Hi all, there is a part in my application where the code needs to execute a query like this SELECT * FROM Items WHERE GUID IN (x,y,z, etc) I know...
The problem is that I have not really payed attention to administering these sql servers. There is only one login (that of the sa user) that...
Hi pros, I have several SQL servers which are used for uploading customers' backups for debuging and other purposes. This is performed by...
Thanks a lot for the immediate response KKT
Does anyone know this? I have a database in SQL Server 2005 with compatibility level 80 (SQL Server 2000). Is it possible to restore the db in...
Separate names with a comma.
