Browse by Tags

SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?

Published 19 May 8 4:28 AM | SSQA.net

To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...

Filed under: sql server, restore, best practices, system, uninstall, windows 2003, cumulative update, downgrade

SQL Server Memory - what's your method on Configuration and Troubleshooting Issues

Published 1 April 8 4:49 AM | SSQA.net

Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as...

Filed under: sql server, performance, memory, cache, disk space, troubleshoot, system, best practice, raid, hardware, monitoring, configuration, baseline

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Published 15 November 7 9:41 AM | SSQA.net

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must...

Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads

Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?

Published 15 October 7 7:59 AM | SSQA.net

How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with...

Filed under: sql server, function, system, stored procedure, tsql, best practice, information schema, views, triggers

TSQL to get an index age in a database

Published 6 September 7 8:37 AM | SSQA.net

SELECT ‘Index Name’ = ind . name , ‘Statistics Date’ = STATS_DATE ( ind . object_id , ind . index_id ) FROM SYS.INDEXES ind WHERE OBJECT_NAME ( ind . object_id ) = ‘Table_Name’...( read more ) Read More...

Filed under: sql server, indexes, system, age

TSQL to generate GRANT statements from a database

Published 17 August 7 5:45 AM | SSQA.net

select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions...

Filed under: sql server, performance, access, permission, system, tsql, grant

TSQL methods to display the owner of schema in a database.

Published 15 August 7 4:23 AM | SSQA.net

You can use 2 methods to get information about owner of a particular schema or set of schema(s) within the database. Using INFORMATION_SCHEMA views method (which I prefer most of the times): USE <DBName> GO SELECT * FROM INFORMATION_SCHEMA.SCHEMATA...

Filed under: system, tsql, information schema, catalog

32bit vs 64 bit what other factors you need to consider?

Published 14 August 7 8:16 AM | SSQA.net

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of...

Filed under: sql server, performance, memory, server, windows, x64, system, hardware, 32 bit, 64 bit

Is it possible to restore all databases from Enterprise Edition to Standard Edition in SQL Server?

Published 2 July 7 5:3 AM | SSQA.net

Question> Is it possible to restore all the databses from Enterrise Edition to Standard Edition in SQL Server? Answer> Yes and No! Yes is you can restore user databases ( only ) from Standard Edition to Enterprise Edition and vice-versa for further...

Filed under: sql server, databases, move, system, password