It returns true if a column was updated. An update means that the query has SET the value of the column. Whether the previous value was the same as the new value is largely irelevant. UPDATE table SET col = col it’s an update. UPDATE table SET col = 99 when the col already had … Read more
You should first figure out what it was doing, where it came from, and if applicable how much longer it might be expected to run: SELECT r.[session_id], c.[client_net_address], s.[host_name], c.[connect_time], [request_start_time] = s.[last_request_start_time], [current_time] = CURRENT_TIMESTAMP, r.[percent_complete], [estimated_finish_time] = DATEADD ( MILLISECOND, r.[estimated_completion_time], CURRENT_TIMESTAMP ), current_command = SUBSTRING ( t.[text], r.[statement_start_offset]/2, COALESCE(NULLIF(r.[statement_end_offset], -1)/2, 2147483647) ), … Read more
There was a nice research paper published by Microsoft Research called To Blob or not to Blob where they looked at all sorts of variables and impacts. Their finding in the end: up to 256 KB in size, blobs are stored in the database more efficiently than in the file system for 1 MB and … Read more
A default schema is user-specific: USE yourDatabase; ALTER USER [yourUser] WITH DEFAULT_SCHEMA = myschema; More information about the ALTER TABLE for SQL 2005 might help you as well. As this is user-specific, if you have multiple users, you will need to execute this query (on each database) for each user whose default schema you want … Read more
You can consult the two system catalogs sys.server_principals to check for server logins, or sys.database_principals in your specific database for users of your database: use myDB GO if not exists(select * from sys.database_principals where name=”foo”) — create your database user if not exists(select * from sys.server_principals where name=”foo”) — you need to create a server … Read more
Check out the sys.assembly_modules view: select * from sys.assembly_modules This should list all functions and the assemblies they’re defined in. See the Books Online help page about it. Returns one row for each function, procedure or trigger that is defined by a common language runtime (CLR) assembly.
Your problem is: you have XML with an encoding=”utf-16″, but your column is a non-Unicode column…… Assuming that you cannot change it to NTEXT either, you have to do two nested CAST to achieve what you’re looking for: SELECT CAST(CAST(XML AS NTEXT) AS XML).value(‘(/Record/UserGuid)[1]’, ‘NVARCHAR(max)’) FROM tbl_Module_RequestForms_Items First, you need to cast to NTEXT (or … Read more
Note that this change is a size-of-data update, see SQL Server table columns under the hood. The change will add a new NVARCHAR column, it will update each row copying the dta from the old VARCHAR to the new NVARCHAR column, and then it will mark the old VARCHAR column as dropped. IF the table … Read more
We can use below scrip to disable indexes ALTER INDEX ALL ON [TableName] DISABLE; Do your bulk insert to table and than run below script. ALTER INDEX ALL ON [TableName] REBUILD;
I think that Open DBiff does a good job. It’s simple and I works with SQL Server 2005/2008. But only generate the change script. Nothing more and nothing less.