Subscribe

Topic: T-SQL

New with Topic: T-SQL


pinaldave
pinaldave posted a blog entry
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - Day 3
Yesterday was our last day at South Asia MVP Open Day. For three days continuously we are having great time along with fellow...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - Day 2
At MVP Open Day we were promised that we will have 8 to 8 action packed day but we all observed much longer hours where we all...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - Day 1
It is great fun! Perfect Event and Great start.Yesterday I wrote about agenda of South Asia MVP Open Day 2008 which is at...
 
DBAdmin
DBAdmin posted a blog entry
Creating SQL Server Login From A Domain Account To Access System Directory
I was having a problem accessing a folder via an extended procedure. The extended procedure accepts a DirectoryInfo variable...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - Link List
Today is very exciting day as I will start my trip to South Asia MVP Open Day 2008 - Goa. Yesterday I wrote about my visit. I...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
I will be attending South Asia MVP Open Day 2008 on November 15 - 17, 2008 at Hotel Kenilworth Resorts, Goa. I am very excited...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - RML Utilities - Usage and Additional Help
Yesterday I wrote about SQLAuthority News - Download RML Utilities for SQL Server. I received many emails where different...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Download RML Utilities for SQL Server
The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Delete Backup History - Cleanup Backup History
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Check Database Integrity for All Databases of Server
Today we will see quick script which will check integrity of all the database of SQL Server.EXEC sp_msforeachdb...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - SQL Server 2008 Book Online Updated in October 2008
SQL Server 2008 Books Online is updated on 31 October 2008. I always bookmark latest BOL for my easy reference.Getting...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER 2008 - Connect Visual Studio 2005 Patch Download
It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Refresh Database Using T-SQL
Yesterday I received following questions on blog. Ashish Agarwal asked following question.Hi Pinal,Can we refresh a database...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - 5 Millions Visitors - 2 Anniversary - Authors Note on Economy Slow Down and Job Opportunity - SQL Server
I just received following screen shot from one of the regular reader of SQLAuthority.com blog. He pointed out important...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Clear Drop Down List of Recent Connection From SQL Server Management Studio
Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL...
 
Thomas Williams
Thomas Williams bookmarked a link
My stored procedure "best practices" checklist
A well-written article explaining how Aaron formats SQL code to his own preference to improve readability, which has generated a few good discussion points (I too don't understand the habit of putting comma's at the start of a line). Some of...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Fix : Error: 4064 - Cannot open user default database. Login failed. Login failed for user
I have received following question nearly 10 times in last week though emails. Many users have received following error while...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - SQL Server Security Whitepapers
Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
Recently I have got two desktop computers at home and both of them are very powerful machine.Machine 1 : Windows Vista SP1...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Stored Procedure WITH ENCRYPTION and Execution Plan
Stored Procedures are very important and most of the business logic of my applications are always coded in Stored Procedures....
 
pinaldave
pinaldave posted a blog entry
SQL Server - DECLARE Multiple Variables in One Statement
Just a day ago, while I was enjoying mini vacation during festival of Diwali I met one of the .NET developer who is big fan of...
 
DBAdmin
DBAdmin posted a blog entry
How To: Summarize Aggregated Data Using Pivot in TSQL
This question posted on StackOverflow.com caught my attention. This is a common data requirement specially in Data Analysis. It...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Download Microsoft SQL Server Management Pack for Operations Manager 2007
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008...
 
Zafar Iqbal
Zafar Iqbal shared an item
System function to return just the date and no time
You will notice a DATE related theme of the posts today. This one is about the lack of a system function that returns JUST the date and DOESNT include any tiem component.Due to time constraints they didn't include such a function, seems like a car...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Download SQL Server 2005 Service Pack 3 - CTP
The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Happy Diwali to All of You
SQLAuthority Wishes Happy Diwali to All of You      
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Download Microsoft SQL Server 2008 Feature Pack, October 2008
Microsoft ADOMD.NETADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Simulate INNER JOIN using LEFT JOIN statement - Performance Analysis
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - TOP Downloads - Bookmark
Recently I have got many many request for SQL Server Interview Questions and Answers as well related articles. It seems many...
 
pinaldave
pinaldave posted a blog entry
Author Visit - MVP Open Day 2008 - Goa - November 15-17
I will be attending MVP Open Day 2008 in Goa from November 15 to November 17. I am eagerly waiting to attend the Open Day. If...
 
Dave
Dave posted a blog entry
SQL CURSOR Performance - SQL For Programmers
Last week I showed how to use the SQL CURSOR to loop through records in a database.  In that article I mentioned that you want...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept
This article is inspired from two sources.1) My year old article - SQL SERVER - Effect of TRANSACTION on Local Variable -...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Introduction to CLR - Simple Example of CLR Stored Procedure
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2
A year ago I wrote post about SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice where I have...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Get Common Records From Two Tables Without Using Join
I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Ahmedabad SQL Server User Group Meeting - October 2008
Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Downgrade Database to Previous Version
Today I am writing on the topic which I do not like to write much. I enjoy writing usually positive or affirmative posts....
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Introduction and Example of UNION and UNION ALL
It is very much interesting when I get request from blog reader to re-write my previous articles. I have received few request...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - Get Numeric Value From Alpha Numeric String - UDF for Get Numeric Numbers Only
SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see User Defined Function, which...
 
Dave
Dave posted a blog entry
SQL CURSOR - SQL For Programmers
One of the things it took me a while to figure out was how to get a stored procedure to loop through data in a table and pull...
36 days ago DMB Consulting | Topics: SQL For..., cursor, fetch, sql
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Book Review - Pro SQL Server 2005 Replication (Definitive Guide)
Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover)by Sujoy Paul (Author) Link to Amazon (This is not affiliate...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - SQL Injection - SQL Joke, SQL Humor, SQL Laugh
It has been long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by...
 
pinaldave
pinaldave posted a blog entry
SQLAuthority News - Download - Microsoft SQL Server 2008 Feature Pack, August 2008
Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide...
 
pinaldave
pinaldave posted a blog entry
SQL SERVER - 2008 - Enhenced TRIM() Function - Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
After reading my article SQL SERVER - 2008 - TRIM() Function - User Defined Function, I have received email and comments where...
 
BCoelho2000
BCoelho2000 posted a blog entry
Search for tables with schema differences in SQL Server
Do you want to know how to search for tables with schema differences in SQL Server?You've come to the right place!Follow me as...