Damien_The_Unbeliever

441 reputation

bio	website	damientheunbeliever.blogspot.…
	location	United Kingdom
	age	35
visits	member for	1 year, 3 months
	seen	yesterday
stats	profile views	32

Generalist, currently in a (C#/VB.Net/SQL Server) Systems department of a Charity, producing Fat Clients and Web Apps (and utilities for other devs, and anything else I can find to play with)

	441 reputation	bio	website	damientheunbeliever.blogspot.…	visits	member for	1 year, 3 months
14 badges		location	United Kingdom		seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

53 Actions

suggestions reviews revisions comments badges posts accepts all

2d	comment	Use second hard disk for database if first one is full Whilst SQL Server can use multiple files for a single database, there's more planning required around it than just "use the next hard disk"
May 17	comment	Re enable Windows Authetication in SQL Server See e.g. this question (The same steps should work for non-Express editions)
May 15	comment	SQL Server installation prerequisite fails Maybe `View detailed report` or `Failed` link to information that helps you. What have you tried?
May 13	comment	One database or multiple referencing one? I flagged for redirect to dba.stackexchange, since I thought your question may be a better fit for there. If you want the master tables present in each application database, then you can look into the various replication options that SQL Server supports. There's nothing to stop you have a mix of replicated and non-replicated tables inside the same database. This may be beneficial to setup now if you expect that you may outgrow a single instance and want to split databases onto different servers.
May 13	comment	One database or multiple referencing one? The most important thing (IMO) to consider is where the transaction/recovery boundaries lie - if one application needs to have its data rolled back/recovered from backup, does that imply that every application should similarly be rolled back? If it does, they should be in the same db. If it doesn't then separate DBs may be indicated.
May 8	comment	Trigger Performance : Is Using Trigger is a good way? 600-700 calls per hour == 10-11 calls per minute == less than 1 call per second (on average). That's not "frequently" (compared to some systems)
May 8	comment	Trigger Performance : Is Using Trigger is a good way? 10K is not a lot of rows. You'd need to define "occur very frequently" more clearly. There are several options for auditing (triggers, CDC, Change Tracking) which you can probably get recommendations for on dba.stackexchange, if you can more clearly define your requirements.
May 1	comment	Database Restore Failed Due to Incompatible Version of SQL Server Compatibility setting doesn't affect the version stored in the mdf file, which is what ends up in the backup.
Apr 2	comment	SQL Server uses only 1 CPU of 4 available Depends on what you mean by "CPU". The actual restriction is "Limited to lesser of 1 Socket or 4 cores"
Mar 5	answered	Restoring a differential backup in SQL server 2005
Feb 7	comment	How to replicate from SQL Server 2000 to SQL Server 2008 R2? Can you not add primary keys to those tables which are missing them?
Feb 2	awarded	Yearling
Jan 18	comment	Internal architecture of cursors It depends on what options are selected in the `DECLARE CURSOR`. As to memory usage, that's separate from cursors. SQL server tries to keep as many pages from tables in memory as possible (whilst trading off against other possible memory usage)
Jan 7	comment	Oneway sync of two SQL Servers via FTP If the data is only flowing from master to replicas, you might consider other forms of replication, such as snapshot. I'm fairly sure you can use snapshot via FTP only.
Jan 3	comment	SQL Server drop and create all users in every DB You've linked to a KB article that describes situations encountered when migrating a version 7 database to 2000 or 2005. Hmm. Does that match what you're describing? For most situations, `sp_change_users_login` with `Auto_Fix` has sufficed for me. But this isn't a programming problem.
Oct 30	comment	How many connections reads queue How would it know? There's no requirement that these external tasks maintain a connection to the server at all times, nor that they notify the server when they shut down, nor even that the process that is launched isn't just a bootstrap process that launches the real external task that reads from the queue.
Oct 19	comment	Can you set up a SQL server maintenance plan to restore a database? Do you need Database2 to exist afterwards? There's an option to verify the backup, which actually runs a restore (but doesn't leave a database behind)
Oct 12	comment	SQL Server Schema Security Does it fail with a message saying "permissions failure", or does it actually include useful information in the error message? Also, have you applied any other permissions to this user?
Oct 9	comment	Deny access to information schema in SQL Server I'm not sure that a correct ANSI SQL implementation is allowed to not allow the user to query `INFORMATION_SCHEMA` (for those objects that they have permission to)
Oct 3	comment	Set priority for an SQL Server role Usually, `DENY` should only be used when you're dealing with nested roles, the "outer" role has been `GRANT`ed some permission, and you wish to prevent someone with the "inner" role from using that permission. It sounds like staff is the "outer"-most role - they shouldn't have any `DENY`s.