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 News - SQL SERVER 2008 - New Logo
2008-05-26 03:30:00 Microsoft SQL Server 2008 has new logo. I really liked the new design. More About: News , Technology , Database , Logo
SQL SERVER - T-SQL Script to Devide One Column into Two Column
2008-05-25 03:30:00 Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns. It was interesting that value of the column was variable and something dynamic needed to be written. Following is quick script which separates one column ... More About: Script , Column , Server
SQL Authority News - SQL Server Interview Questions - SQL Related Jobs - DB
2008-05-24 03:30:00 I like to help every candidate who are finding job. I have previously written article here which can help all the people who are looking for job or looking for candidates. SQL Server Interview Questions and Answers Complete List Download Find Job Related to SQL SERVER SQL Server DBA- Job Description More About: News , Technology , Jobs
SQL SERVER - SQL SERVER - UDF - Get the Day of the Week Function - Part 2
2008-05-23 03:30:00 I have written article about SQL SERVER - UDF - Get the Day of the Week Function . I have received good modified script from reader Mihir Popat has suggested another code where Sunday does not have to be necessary the first day of the week. CREATE FUNCTION dbo.udf_DayOfWe ek(@dtDate DATETIME) RETURNS VARCHAR(10) ; AS BEGIN DECLARE @rtD ayofWeek VARCHAR(10) DECLARE @wee kDay INT ; – Here I have subtracted 7 For kee ping Sunday as the Fi rst day ; – like wise f or Monday we need to& #160;subtract 2 and so 0;on ; SET @weekDay = ((DA TEPART(dw... More About: Server , Part
SQL SERVER - PIVOT Table Example
2008-05-22 03:30:00 This is quite a popular question and I have never wrote about this on my blog. A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, ... More About: Server
SQL SERVER - 2005 - Twelve Tips For Optimizing Sql Server 2005 Query Perfor
2008-05-21 03:30:00 I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering Indexes 5. Keep your clustered index small. 6. Avoid cursors 7. Archive old ...
SQL SERVER - 2008 - Choosing the Right Edition for Your Needs
2008-05-20 03:30:00 Enterprise SQL Server 2008 is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications. Standard SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications. Workgroup Run branch locations on this reliable data management and reporting platform ... More About: Technology , Edition
SQLAuthority Download - Providing Security for Web Applications and Infrast
2008-05-19 03:30:00 Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks The Windows Live Security team shares best practices - from platform and network security to incident management - in providing security for web applications and infrastructure. Organizations across the globe face unique challenges in enhancing security for Web applications and their IT infrastructures. Issues ... More About: Download
SQLAuthority News - SQL SERVER Database Administrator Job Description
2008-05-18 03:30:00 I have previously written article about SQLAuthority News - Job Description of Database Administrator (DBA) or Database Developer. I have received quite a lot of request to update it or post something similar. Writing SQL Articles are easier then writing Job description for DBA. I have read many job description and job posting at Best ... More About: Server
SQL SERVER - Ideal TempDB FileGrowth Value
2008-05-17 03:30:00 Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site. I found following answer and I think it is quite interesting. tempdb file size - FILEGROWTH increment ... More About: Ideal
SQL SERVER - Find Table in Every Database of SQL Server - Part 3
2008-05-16 03:30:00 Previously I wrote two articles about SQL SERVER - Find Table in Every Database of SQL Server SQL SERVER - Find Table in Every Database of SQL Server - Part 2 I recently received email from SQL Expert and Blog Reader Greg Steinkuhler. People like Greg Steinkuhler makes this whole world better place. He wrote absolutely wonderful ...
SQL SERVER - SQL Joke, SQL Humor, SQL Laugh - Silly Mistake
2008-05-15 03:30:00 It is really very bad of person to laugh on others misfortune, however dark humor is based on the same concept. It has been long time since I wrote something funny on this blog. Recently, I have came across forum discussion regarding backup misery of one of the developer. I feel very sorry for the ... More About: Humor , Joke , Server , Silly , Laugh
SQL SERVER - Orphaned MS DTC Transaction Information
2008-05-14 03:30:00 Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we figured out the case of it was orphaned MS DTC transaction. When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connection are working none of them try to roll ... More About: Information , Server
SQL SERVER - Four Basic SQL Statements - SQL Operations
2008-05-13 03:30:00 There are four basic SQL Operations or SQL Statements. SELECT - This statement selects data from database tables. UPDATE - This statement updates existing data into database tables. INSERT - This statement inserts new data into database tables. DELETE - This statement deletes existing data from database tables. If you want complete syntax for this four basic statement, please download ... More About: Server , Basic
SQL SERVER - SQL SERVER - Comparison : Similarity and Difference #TempTable
2008-05-12 03:30:00 Some questions never get old. One of them is temp table variable and temp table in SQL Server . I have previously wrote about this indepth here : SQL SERVER - Comparison : Similarity and Difference #TempTable vs @TempVariable Recently I received question: Can temporary table have indexes? If yes, are they really useful and efficient? When nonclustered index ...
SQL SERVER 2005 - Microsoft Will Release SP3 Soon
2008-05-11 03:30:00 I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not? Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here. Reference : Pinal Dave (http://www.SQLAuthority.com) More About: Technology , Database , Release
SQL SERVER - Function Property - Deterministic or Non-Deterministic
2008-05-10 03:30:00 I recently received question through email that how to determine if any user defined function is deterministic or non-deterministic? First go through two articles I have written about deterministic and non-deterministic function. SQL SERVER - Deterministic Function s and Nondeterministic Functions SQL SERVER - 2005 - Use of Non-deterministic Function in UDF - Find Day Difference Between Any Date ... More About: Property , Server
SQL SERVER - FIX : Error 7311 - You may receive an error message when you t
2008-05-09 03:30:00 Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers. Hi Pinal, Recently, I’ve a problem on create and ... More About: Message , Error
SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database - P
2008-05-08 03:30:00 What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for any blog or online community. Recently many readers have contributed their suggestions and script to this blog. Joffery has provided nice script which is modification to previous article of SQL SERVER - 2005 - Find ... More About: Tables , Database , Server , Foreign
SQL SERVER - Create Database Error in Windows Vista
2008-05-07 03:30:00 I recently receive question from one of the blog reader that he is having problem creating database in Windows Vista . Read original comment here. I have installed vista ultimate and sql server 2005 devloper edition in my computer.I also connect sql 2005 in window authentication but when I CREATE any database in following query CREATE DATABASE MANEESH USE ... More About: Technology , Windows Vista , Database
SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication
2008-05-06 03:30:00 In previous post I have mentioned about SQL SERVER 2005 - Vista Ultimate and SQL Server 2005 DEV Edition. There was one simple issue with the installation. I was not able to login using windows authentication method. I was able to successful login using sa username and password. I kept on receiving following error. TITLE: Connect to ... More About: Windows , Authentication , Error
SQL SERVER - Find Table in Every Database of SQL Server - Part 2
2008-05-05 03:30:00 Long time blog reader and SQL Server Expert Simon Worth has suggested two additional method to achieve same results as described in article SQL SERVER - Find Table in Every Database of SQL Server. Method 1 sp_msforeachdb "SELECT R 17;?' DatabaseName, Name F ROM ?.sys.Tables WHERE Nam e LIKE ’%address%’& #34; ; Method 2 CREATE TABLE #TableNameResults& #160;(DatabaseName VARCHAR(100) ;NOT NULL, TableName VARCH AR(100) NOT NULL) INSERT INTO #TableNameResults&# 160; EXEC sp_msfo reachdb "SELECT ’?'&# 160;DatabaseName, Name FROM 0;?.sys.Tables WHERE Name LIKE ’%address%’" SELECT * FROM #TableN ameResults DROP TABLE #TableNameResults ... More About: Part
SQL SERVER - 2000 - SQL SERVER - Delete Duplicate Records - Rows - Readers
2008-05-04 03:30:00 I am proud on readers of this blog. One of the reader asked asked question on article SQL SERVER - Delete Duplicate Records - Rows and another reader followed up with nice quick answer. Let us read them both together. Question from Mayank Mishra Is it possible to delete a single column from a table in SQL ... More About: Readers , Server
SQL SERVER 2005 - Vista Ultimate and SQL Server 2005 DEV Edition
2008-05-03 03:30:00 I have been asked many times before “Does SQL Server Dev edition can be installed on Vista operating system?” I decided to find out the answer of this myself. I have just got new system which has Vista Ultimate Installed on it. I installed SQL Server 2005 dev edition on it. While installing it suggested that ... More About: Edition
SQL SERVER - How to Rename Database Objects to Comply With Naming Conventio
2008-05-02 03:30:00 Christopher Miller read article of SQL SERVER Database Coding Standards and Guidelines Complete List Download and came up with wonderful SQL Server Script to rename all their database constraint with more organized constraint names, which helps to easily identify the constraint database exist on. Christopher Miller - “When we submit our schema updates internally, we usually ... More About: Technology , Rename , Objects
SQLAuthority News - Write for SQLAuthority
2008-05-01 03:30:00 I always enjoy writing for my readers. Many times, I receive very good note, comments or article from my great experts of SQL Server. I really enjoy learning from my reader. If you are reader of SQLAuthority and you think you have knowledge, script or concept which benefit other readers of this blog, please feel free ... More About: News , Write
SQL SERVER - Find Table in Every Database of SQL Server - Part 2
2008-04-30 03:30:00 Yesterday I wrote about SQL SERVER - Find Table in Every Database of SQL Server . Today we will see another method how we can achieve the same result using Information_Schema view. Refer my previous article here for additional information. CREATE PROCEDURE usp_FindTableN ameInAllDatabase @TableName V ARCHAR(256) ; AS DECLARE @DBName VARCHAR(256) DECLARE @varSQL VARCHAR(512) DECLARE @getDBName CURSOR SET @getDBNa me = CURSOR FOR SELECT name FROM sys.dat abases CREATE TABLE #TmpTable (TA BLE_CATALOG VARCHAR(128), TABLE _SCHEMA VARCHAR(128), TABLE_NAM E VARCHAR(256), TABLE_TYPE ;VARCHAR(10)) OPEN @getDBName ; FETCH ;NEXT FROM ... More About: Part
SQL SERVER - Find Table in Every Database of SQL Server
2008-04-29 03:30:00 Just a day ago, one of the Jr. Developer requested that if I can help her with finding one particular table in every database on SQL Server . We have many Database Server and on some of the Database Server we have nearly 200 databases on it. The requirement was to find out one particular table ... More About: Find , Table
SQL SERVER - Download FAQ Sheet - SQL Server in One Page
2008-04-28 03:30:00 One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion ... More About: Download , Page , Sheet
SQL SERVER - Query Analyzer Shortcuts - Part 2
More articles from this author:2008-04-27 03:30:00 I enjoy reader’s articles to read as much as I enjoy expert’s articles. One of blog reader Praveen Barath always have good ideas to share. Here is Praveen Barath’s comment on my previous article Query Analyzer Shortcuts . MSSQL server 2005 is a database platform , Platform because from one window you can connect to any of ... More About: Server , Part 1, 2, 3, 4, 5, 6, 7 |
|
 |
|
 |
