Tag Info

Hot answers tagged

6

I am a big advocate of keeping up to the date with the most recent cumulative update, but only if your testing/QA cycle can ensure full and proper regression testing against it. Glenn Berry of SQLskills is also a proponent of this approach. Microsoft's own recommendation is to only apply CUs that fix issues that affect you. The problem is that you may be ...


6

You can use sys.dm_db_index_physical_stats to identify the size of your partitions and how much space is being used. Use the page_count field to see the size of your partition. If you perform a SAMPLED or DETAILED scan, you will also get a value for avg_page_space_used_in_percent, which will allow you to estimate how much of the space in the partition is ...


3

We used to keep up with the CU's. Approximately 1 month after release we would apply them whether we were experiencing an issue corrected by them or not. However, after we ran into a huge problem we stopped this practice. In our case a service pack we had installed fixed a problem with full-text indexing that we were experiencing. A few months later, one ...


3

Use mysqli or PDO libraries for PHP, do not use mysql, as it is deprecated Use prepared statements: they are cleaner, less prone to SQL injection and, in some cases, faster to execute Use exceptions to capture errors throughout your code -query fails, query gets killed, database crashes, unable to connect, ... If you feel intimidated by SQL, an ORM can help ...


2

I guess this is a known issue and Microsoft has released information about it in below links Cause: This issue occurs because the "tran_sp_MScreate_peer_tables" transaction was left open by a replication upgrade script during the upgrade. This open transaction prevents usual log truncation. Transaction log for database is growing with system SPID as open ...


2

The column max_length is the maximum column length in bytes. For the National-Character set string types (NCHAR and NVARCHAR), each character requires two-bytes, so NCHAR(10) would have a max_length value of 20.


1

The first query returns the count of rows across a given load_date. Whereas the second query gives you the count of rows for maximum load_date. Say you have 2 dates. First query returns : LoadDate. Count(*) 03-04-2014. 12 03-05-2014. 11 Second query returns: Max(loadDate). Count(*) 03-05-2014. 23 If you ...


1

I wouldn't worry if I were you. Many systems (Oracle's EBS e-business suite) have gazillions (a techical term meaning a large number) of tables, most of which will never be used by many customers. Any major e-commerce/ERP/ERM system will be like this. You'll find that you'll be spending 85% of your time working with just a few modules which are core to your ...


1

Transaction log for the database is growing and system SPID is holding open transaction. If you see Name user_transaction then script upgrade for database has failed leaving an open transaction. Verify the SQL Server error log to identify why the script upgrade has failed. You need to enable Trace flag -T3601 which causes the first 512 characters of each ...


1

Is there any trace flag enabled or any tweaking into startup parameters of SQL server can you please check that.Have a look at below Microsoft support article http://support.microsoft.com/kb/2199576/en-us Keep max lock value to default EXEC sp_configure 'locks', 0 ( I guess you tried this option already) Now if you face this issue again best possible ...



Only top voted, non community-wiki answers of a minimum length are eligible