Tag Info

New answers tagged

1

I love Aaron Bertrand's answer. Although I don't understand it completely, it looks really elegant. In the past I've ran into problems with permissions when using sys.objects. Combined with the need for me to troubleshoot the code, I've come up with a variation on Aaron's code, and added it below. This is my procedure: CREATE PROCEDURE ...


1

You will almost always be susceptible to vendor updates when it comes to schema changes and their app, especially when it comes to ERP applications such as SAP Business One or it's bigger brother. The issue is how will their update scripts react to your table being added/modified? Usually it's not a big deal for me but sometimes it could cause massive ...


1

Index Scan scans each and every record in the index. Table Scan is where the table is processed row by row from beginning to end. If the index is a clustered index then an index scan is really a table scan. Since a scan touches every row in the table whether or not it qualifies, the cost is proportional to the total number of rows in the table. Index Seek: ...


-1

although this is answered I just though it would be nice to drop this little line of code that does exactly the filtering most people want and sets AUTO_SHRINK OFF: EXECUTE sp_MSforeachdb 'IF (''?'' NOT IN (''master'', ''tempdb'', ''msdb'', ''model'')) EXECUTE (''ALTER database ? SET AUTO_SHRINK OFF'')


2

For the unused stored procedures you can make use of dmv's especially sys.dm_exec_procedure_stat. To find unused stored procs, please see the answer as explained by Aaron Bertrand. Also, there is an good read to identify as explained here in the article How to find unused Stored Procedures in SQL Server 2005/2008 To tack down unused views: a) ...


0

I was getting the same error, i was using a proxy account with my own database security credentials, and the password had changed. Once i changed it in the security ->credentials, the package started working..


0

Also, is the Services section in SQL Server Configuration Manager just a "shell" of the full Services screen, which is limited to SQL Server related services? Yes, SQL SCM is the SQLServerManager10.msc file that is opened as a snap-in Windows Management Console (mmc.exe). Is there any reason not to stop and start SQL Server services from the full ...


1

Version store basically cause from long running transaction or high transaction throughput. You need to look for the queries which are causing this. Other than that version store is used in following conditions: Row version which are generated by data modification transactions for features (MARS, online indexes, AFTER trigger etc) Row version which are ...


1

How to rename sa to new_sa in SQL Server 2000? How to do and what is the impact I'm not sure how to rename sa in SQL 2000 or even if you can that far back. SA rename impact in SQL Server 2005, 2008, 2008R2, 2012, 2014, Express Edition I have heard of this as a best practice from some people. To the best of my knowledge there is no effect other than trying ...


0

Well you can try to run a trace (if it's possible for you). But you can also try to just write it to your SQL Server Agent Job History instead. I tried to write a little bit of code which can be added as a first step in front of all other steps. It will simply write a line "Executed from [hostname]". I couldn't test it, due to the fact that I have just one ...


-1

Here is a good article that explains what the Transaction Log is, and why do you need one!


1

This is due to the fact you reached the row size limitation. But this should affect your production server too? Are you sure that both server are the same and both server use the same table design? You can try to use nvarchar(max) instead of (e.g). nvarchar(250) for testing purposes. This will use more space and will be slower, but will avoid the 8060 ...



Top 50 recent answers are included