SQL Archives - Page 481 of 519 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Multiple Language Support

September 21, 2007

SQL Server supports multiple languages. Information about all the languages are stored in sys.syslanguages system view. You can run following script in Query Editor and see all the information about each language. Information about Months and Days varies for each language. Syntax: SELECT Alias, * FROM sys.syslanguages ResultSet: (* results…

SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full

September 20, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

ERROR : 3260 An internal buffer has become full The reason I have picked to write about this error is because we have encountered this error many times in one of our older server. Fix/WorkAround/Solution: We were not able to absolutely reduce this error but following changes helped. 1) Rebooted…

SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode

September 19, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Stored Procedure

In my organization we rename the database on development server when are refreshing the development server with live data. We save the old database with new name and restore the database from live with same name. If developer/Jr. DBA have not saved the SQL Script from development server, he/she can…

SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots

September 18, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Data Warehousing, Database, SQL White Papers

White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services. This architecture provides the following improvements Improves the utilization of disk resources Optimizes cube processing operations Supports dedicated snapshots for specific users at different points…

SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function

September 18, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Few days ago I wrote SQL SERVER – UDF – Validate Integer Function. It was very interesting to write this and developers at my company started to use it. One Jr. DBA modified this function to validate only positive integers. I will share this with everybody who are interested in…

SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management

September 17, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Data Warehousing, Database, DBA, SQL Server

I just came across PDF published by Microsoft to promote SQL Server 2005. I find few things very interesting. I will list them here.

NASDAQ

SQL SERVER – Difference Between UPDATE and UPDATE()

September 17, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

What is the difference between UPDATE and UPDATE()? UPDATE is syntax used to update the database tables or database views. USE AdventureWorks ; GO UPDATE Production.Product SET ListPrice = ListPrice * 2; GO UPDATE() is used in triggers to check update/insert to the database tables or database views. Returns a…