Journey to SQL Authority with Pinal DaveJourney to SQL Authority with Pinal DavePinalkumar Dave is the author of many SQL Server articles. He has five years experience as a Principal Database Administrator and Web Application Architecture Developer in MS SQL Server 2005 2000 and ColdFusion MX. He has a Masters of Science degree Articles
SQLAuthority New - Microsoft SQL Server 2008 and System Center - Managing,
2008-02-27 02:30:00 System Center is Microsoft ?s family of systems management solutions designed to make IT more productive and efficient by allowing the IT department to apply best practices to systems management, deployment, and data protection. System Center Operations Manager 2007 Inventory discovery and management Events and alerts display Multiple views ready to use out-of-the-box System Center Configuration Manager 2007 Deploy consistent instances of ... More About: Technology , System , Database , Server
SQL SERVER - SELECT 1 vs SELECT * - An Interesting Observation
2008-02-26 02:30:00 Many times I have seen issue of SELECT 1 vs SELECT * discussed in terms of performance or readability while checking for existence of rows in table. I ran quick 4 tests about this observed that I am getting same result when used SELECT 1 and SELECT *. I think smart readers of this blog ... More About: Interesting , Server , Select
SQLAuthority News - Download Upgrade Service Datasheet
2008-02-25 02:30:00 Migration Service (Oracle) This offering gets you up and running by using a migration engagement with a robust new data management platform with its advanced data analysis and reporting Migration Service (Sybase) Datasheet This offering gets you up and running by using a migration engagement with a robust new data management platform with its advanced data analysis and ... More About: News , Technology , Download , Database
SQL SERVER - 2005 - Licensing Model Compared to Other Database Products
2008-02-24 02:30:00 Yesterday on this blog I wrote about SQL SERVER - 2005 - Understanding Licensing Model . I have received many questions about pricing and comparing SQL Server with other RDBMS. One of the reason I like SQL Server because I am strong believer of licensed software usage and SQL Server is feature rich and dirt cheap ... More About: Products , Database
SQL SERVER - 2005 - Understanding Licensing Model
2008-02-23 02:30:00 SQL Server 2005 is available under three different licensing options: * Processor Licensing Model * Server Plus Device CALs Licensing Model * Server Plus User CALs Licensing Model Processor Licensing Model A license is required for each physical or virtual processor accessed by an operating system environment running SQL Server. If SQL Server is connected with many clients and users ... More About: Understanding
SQL SERVER - Find All The User Defined Functions (UDF) - Part 2
2008-02-22 02:30:00 Few days ago, I wrote about SQL SERVER - Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database. USE AdventureWorks GO SELECT specific_name,specific_schema FROM information_schema.routines WHERE routine_type='function' GO Reference : Pinal Dave (http://www.SQLAuthority.com), Madhivanan ... More About: Server , Part
SQLAuthority News - Download SQL Server 2008 February CTP Sample Codes
2008-02-21 02:30:00 As I wrote earlier SQLAuthority News - Download SQL Server 2008 February CTP (CTP 6), Microsoft has released SQL Server 2008 CTP 6. Microsoft has released new updated Samples. Documentation of the updated Samples can be found here. I encourage all my readers to download SQL Server 2008 CTP and experiement with it. If you have ... More About: Technology , Database
SQLAuthority New - SQL Server 2008 Books Online CTP (February 2008)
2008-02-21 02:30:00 Download a Community Technology Preview (CTP) version of the documentation and tutorials for Microsoft SQL Server 2008. SQL Server 2008 Books Online CTP (February 2008 )
SQL SERVER - UDF to Return a Calendar for Any Date for Any Year
2008-02-20 02:30:00 It gives me great pleasure to write articles like today’s one because I have received great comment from one of regular reader who has taken UDF written by me and created another UDF using that UDF which enhances functionality of it. I had written previous article about SQL SERVER - UDF - Function to Display ... More About: Server , Return , Calendar , Year
SQL SERVER - 2005 - FIX: Error message when you run a query against a table
2008-02-19 02:30:00 In SQL Server 2005 while testing Indexes I had created a table with one non clustered index only. I did not create any clustered index on table. After that I ran SELECT statement, it gave me following error. I was very surprised when I looked at error. It says Msg 0, what it means is ... More About: Message , Table , Error , Query
SQLAuthority News - Download SQL Server 2008 February CTP (CTP 6)
2008-02-18 02:30:00 SQL Server 2008 February CTP (CTP 6) has been released. Download from here. It will direct you to page which is dated November 2007. Continue with November 2007 which will take you to February 2008 CTP 6 Download page. Reference : Pinal Dave (http://www.SQLAuthority.com) More About: News
SQL SERVER - How to Escape Single Quotes - Fix: Error: 105 Unclosed quotati
2008-02-17 02:30:00 Jr. Developer asked me other day how to escape single quote? User can escape single quote using two single quotes (NOT double quote). Following T-SQL Script will give error USE AdventureWorks GO SELECT * FROM Person.Address WHERE City = 'Villeneuve-d'Ascq' GO Resultset: Error : 105 Unclosed quotation mark after the character string ‘ To fix the error mentioned above, escape single quotes with two single quotes as displayed in following example. USE AdventureWorks GO SELECT * FROM Person.Address WHERE City = 'Villeneuve-d''Ascq' GO UPDATE : A very good SQL blog Author Madhivanan has written similar article but with good example. Recommended read. More About: Quotes , Server , Single , Escape
SQL SERVER - Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for obj
2008-02-16 02:30:00 There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’. This message is displayed when DBCC command is ran for any database. It is harmless and displayed for information purpose only. For each database DBCC commands displays number of rows and number of pages it is using. DBCC CHECKALLOC is exception for this messages. Reference : Pinal Dave (http://www.SQLAuthority.com) More About: Server , Pages , Ages
SQL SERVER - Index Reorganize or Index Rebuild
2008-02-15 02:30:00 Recently, I have received one question quite often about when to Index Reorganize and when to Index Rebuild. I have already written about this topic earlier but it seems that many are unable to search it. SQL SERVER - Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script If you have any question you can search exclusively SQLAuthority at http://search.SQLAuthority.com More About: Server
SQL SERVER - Introduction to Performance Monitor - How to Use Perfmon
2008-02-14 02:30:00 Yesterday I wrote about SQL SERVER - Introduction to Three Important Performance Counters. I received few questions about how to use Perfmon. Here is very brief introduction to Perfmon. There are three ways to launch Perfmon. 1) Type “start perfmon” at the command prompt. 2) Go to Start | Programs | Administrative Tools | Performance Monitor . 3) Go to Start | Run | Perfmon. Follow the images which explains how to use Perfmon and add different counters. Right click to bring up Add Counters Menu. Reference : Pinal Dave (http://www.SQLAuthority.com) More About: Server
SQL SERVER - Introduction to Three Important Performance Counters
2008-02-13 02:30:00 Performance Counters are very important to evaluate. There are more than thousands of Performance Counters. Today I will cover three basic but very important Performance Counters. Processor:% Processor Time It reports the total processor time with respect to the available capacity of the server. If counter is between 50 to 70 % consistently, investigate the process ... More About: Performance , Introduction , Server
SQL SERVER - Get Current Database Name
2008-02-12 02:30:00 Yesterday while I was writing script for SQL SERVER - 2005 - Find Unused Indexes of Current Database . I realized that I needed SELECT statement where I get the name of the current Database. It was very simple script. SELECT db_name() AS DataBaseName It will give you the name the database you are running using while ... More About: Server
SQL SERVER - 2005 - Find Unused Indexes of Current Database
2008-02-11 02:30:00 Simple but accurate following script will give you list of all the indexes in the database which are unused. If indexes are not used they should be dropped as Indexes reduces the performance for INSERT/UPDATE statement. Indexes are only useful when used with SELECT statement. Script to find unused Indexes. USE AdventureWorks GO DECLARE @dbid INT SELECT @dbid = ... More About: Current , Find , Database , Server
SQLAuthority News - RIP: Ken Henderson, 1967 - 2008
2008-02-10 02:30:00 Ken Henderson , a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects away on Sunday, January 27, in Meeker, Oklahoma. Ken was an inspirational author of the SQL Server Guru’s Guide series of books. We will miss his forever. He was the author I respected the most. I have reviewed his book ... More About: News , Technology , Database , 2008
SQLAuthority News - 2008 - Download - SQL Server 2008 Brochure
2008-02-09 02:30:00 SQL Server 2008 Brochure is available to download. It contains many information like available Server Editions, Top New Features, New Available Technologies and additional resources. Click on above image to open large image. Top New Features Use Resource Governor to manage concurrent workloads Enforce policy compliance consistently across the enterprise with the Policy-Based Management Reduce storage requirements and increase query ... More About: News , Download
SQL SERVER - Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity F
2008-02-08 02:30:00 SQL Server Compact 3.5 SP1 Beta release for the ADO.Net Entity Framework Beta 3 enables the following scenarios: Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships Applications are freed from hard-coded dependencies on a particular data engine or storage schema Mappings between the conceptual application model and ... More About: Technology , Microsoft , Database
SQL SERVER - Sharpen Your Basic SQL Server Skills - Database backup demysti
2008-02-07 02:30:00 Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. More About: Backup , Database , Basic , Skills
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma
2008-02-06 02:30:00 This is very common request recently - How to import CSV file into SQL Server ? How to load CSV file into SQL Server Database Table? How to load comma delimited file into SQL Server? Let us see the solution in quick steps. CSV stands for Comma Separated Values, sometimes also called Comma Delimited Values. Create TestTable USE TestData GO CREATE ... More About: File , Load , Import , Bulk
SQLAuthority News - SQL Joke, SQL Humor, SQL Laugh - Funny Microsoft Quotes
2008-02-05 02:30:00 I have received many emails that I should write more post like SQLAuthority News - SQL Joke, SQL Humor , SQL Laugh - Funny Quotes. If you want to read funny side of SQL and Technology you can surf my blog here SQL Humor. Following article is not copyrighted and is freely available here. “640 K ought ... More About: Microsoft
SQL SERVER - Simple Example of WHILE Loop with BREAK and CONTINUE
2008-02-04 02:30:00 WHILE statement sets a condition for the repeated execution of an SQL statement or statement block. Following is very simple example of WHILE Loop with BREAK and CONTINUE. USE AdventureWorks; GO DECLARE @Flag INT SET @Flag = 1 WHILE (@Flag < 10) BEGIN BEGIN PRINT @Flag SET @Flag = @Flag + 1 END IF(@Flag > 5) BREAK ELSE CONTINUE END WHILE loop can use SELECT queries as well. You can find ... More About: Break , Server , Simple
SQL SERVER - FIX : ERROR : Cannot find template file for new query (C:Progr
2008-02-03 02:30:00 Just a day ago while playing with SQL Server I suddenly faced new kind of error, which I have never seen before. This error happens when clicked on New Query on SQL Server Management Studio. “Cannot find template file for new query (C:Program File sMicrosoft SQL Server90ToolsBinnVSShellCommon7IDEsqlwork benchprojectitemsSqlSQLFile.sql) “ Fix/Workaround/Solution: It was pretty new to me and I could not ... More About: Find , Template , Error
SQL SERVER - Find All The User Defined Functions (UDF) in a Database
2008-02-02 02:30:00 Following script is very simple script which returns all the User Defined Functions for particular database. USE AdventureWorks; GO SELECT name AS function_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc FROM sys.objects WHERE type_desc LIKE '%FUNCTION%'; GO Reference : Pinal Dave (http://www.SQLAuthority.com) More About: Find , Database , Server
SQL SERVER - Find Great Job with Great Pay
2008-02-01 02:30:00 One question I have been asked consistently “Where can I find Great Job with Great Pay related to SQL Server ?”. I have been aware of the fact that there are many jobs in market but finding one job which gives satisfaction in job as well has great salary are few. All the great places ... More About: Find
SQL SERVER - Top 10 Best Practices for SQL Server Maintenance for SAP
2008-01-31 02:30:00 Top 10 Best Practices for SQL Server Maintenance for SAP By Takayuki Hoshino SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation. 1) Perform a full database backup daily 2) Perform transaction log backup Every 10 to 30 minutes 3) Back ... More About: Technology , Data Warehousing , Database
SQL SERVER - FIX : ERROR : The query processor could not start the necessar
More articles from this author:2008-01-30 02:30:00 ERROR : The query processor could not start the necessary thread resources for parallel query execution. Fix/Solution/WorkAround: There is no real solution for this error. This error happens due to server is very busy and it can be resolved itself when server load is reduced to acceptable level. There is no way to know what is acceptable ... More About: Processor , Start , Server , Error , Query 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
