Browse by Tags

SQL Server and Windows Memory

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve memory not in use by other applications and the...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 05-15-2008
SQL Server multiple instances and resource utilization - best practices

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System resources then best to leave the default settings...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 05-15-2008
Simulating undocumented Procedures

Sometimes you may want to run a query against each database Suppose you want to find all dabase names where particular table exists. You can use undocumented procedure EXEC sp_msforeachdb 'SELECT table_catalog FROM ?.INFORMATION_SCHEMA.TABLES where table_name=''your_table''' Because...

Posted to Madhivanan (Weblog) by Madhivanan on 05-13-2008
Common Table Expressions (CTE's) - How it works; How Recursion Works; Using with Adjacency List

Recursion in Common Table Expressions (CTE’s), how does it work? How can I use it with the adjacency list model (parent / child columns)? In this blog entry I show how recursion works, how to use it with the adjacency list model and talk about other aspects and uses for CTE’s; I also demonstrate some...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on 05-11-2008
SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases ETL processes, coming to the point by design...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 05-08-2008
Using the OUTPUT clause on INSERT when loading data using OPENROWSET and BULK operator

Say you have an external file you want to load into your SQL Server database; you need to load – verify – cleanse and insert and at the same time keep a cross reference between the original source file records and the inserted database rows. The OUTPUT clause is an ideal candidate to help you with this...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on 05-05-2008
Object Catalog Views in SQL Server 2005

In addition to INFORMATION_SCHEMA VIEWS, in SQL Server 2005, we can use Object Catalog Views to know more informations about the objects Refer this http://msdn.microsoft.com/en-us/library/ms189783.aspx

Posted to Madhivanan (Weblog) by Madhivanan on 05-03-2008
SQL Server 2008 February CTP Bug Bash Contest Results

Contest-Results

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 05-01-2008
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based RAID. This could be due to one of the reasons such...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 04-28-2008
UK MS Premier Customer? - Premier Field Engineering are hosting an Operations Day for SQL 2008

5th June, Thames Valley Park, Reading sees an Operations Day for SQL Server 2008 for Premier customers only. More information: http://sqlblogcasts.com/blogs/thepremiers/archive/2008/04/27/operations-day-for-sql-server-2008-open-for-premier-customers-only.aspx Don't worry - we've plenty of stuff...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on 04-27-2008

Page 1 of 28 (279 items) 1 2 3 4 5 Next > ... Last »