Viewing 15 posts - 1 through 15 (of 130 total)
The table you describe violates normalization rules and will be inefficient just by the nature of the design. It is my opinion that business/user requirments can state WHAT needs...
October 5, 2012 at 3:12 pm
Statistics are system generated histograms that the optimizer uses to determine the best execution plan for a query. They are objects in the database file so they need to...
September 13, 2012 at 3:57 pm
Make sure you have moved statistics and text/Image data as well. Then you will need to shrink the filegroup you want to delete and then you can drop it.
September 13, 2012 at 3:35 pm
Okay, this sounds like it is database mirroring not replication.
August 31, 2012 at 4:07 pm
Use the GETUTCDATE() function instead of GETDATE() and consider using the datetimeoffset data type to store your values WITH their timezone offsets. Then you can use a simple function...
August 27, 2012 at 2:17 pm
I agree with all the posts that I would prefer to back up to a directly attached disk then move the backup to a network share for Archiving. However,...
August 27, 2012 at 12:08 pm
I have to add my +1 on this. Very bad practice. Just because you can doesn't mean you should.
August 22, 2012 at 4:19 pm
When you restart it in single user mode is there still applications or users that are connecting to the server? if so, then stop them. single user mode...
August 22, 2012 at 12:53 pm
Syntax for connecting with SQLCMD is C:\SQLCMD -S Servername\InstanceName
can you connect with management studio? If so, then add your account as sysadmin then restart the server normally, enjoy. ...
August 22, 2012 at 12:44 pm
At the risk of adding confusion you can connect to an instance using a nonstandard (not dynamic) port and the server name without the browser service.
example: Servername.domainname\instancename,port_number
August 13, 2012 at 5:37 pm
you will probably need to split the IP addresses to deal with the third octet reaching double digits. But with the data you supplied this works:
SELECT B.Building_Name, D.Device_cnt
FROM ...
August 13, 2012 at 4:16 pm
Why wouldn't you just create connections to each server in the SSIS package and then create a dataflow to move data between them? Why the linked servers?
August 10, 2012 at 3:57 pm
I would create a database role for each group of people and only grant the minimum each needs for the tasks they are trying to accomplish and no more.
August 10, 2012 at 3:42 pm
sys.master_files reports the size of the data file in 8k pages. The backup consists of only the data pages that have been used.
August 10, 2012 at 3:18 pm
Viewing 15 posts - 1 through 15 (of 130 total)