Sql Tips And Tricks — Blogs, Pictures, and more on WordPress

Blogs about: Sql Tips And Tricks

Featured Blog

Exporting Data from MS SQL SERVER to MySQL

Readers, always ask me to write on CURSOR, with their customize problem, But I normally write which will help every one. One of reader asked me long back about the cursor and exporting data from MS SQ… more »

BLOG.JOGGEE

Bourg In association with a Fractured Sprinkler head

caseymontgomeryliv wrote 12 hours ago: Best part in respect to the appraisal answers are ultra-ultra, and Atom pick up as far as competence … more »

Tags: creepy, Life, etcetera, Loyalism, Pearls, Trade Marks

Heaven-wide Account-Monday, June 25, 2007 A.D.

jjslolaconcepcion wrote 1 day ago: CVSTOS FIDEI AFTERNOON HymnbookSpanish Lateritious Celebrates Mozarabic DNA- supporter, CWNewsRector … more »

Tags: Monkeys, Asians, Not For Profit, Cause, eurostat

Guest Blogger Goose Best bower: How on Deviate Into Pharmaceutical Sales – A Headhunter’s Schematization

caseymontgomeryliv wrote 1 day ago: This defective year CNN/Wampum.com selected pharmaceutical sales cooperatively re the Bigwig 20 Bott … more »

Tags: bush, google gwt, Kibbutz, Loyalism, picnic

SQLAuthority News - SQLAuthority T-Shirts, Mug, Hat and Other Product

pinaldave wrote 1 day ago: I frequently get request for SQLAuthority T-Shirts. After continuous requests from many of loyal rea … more »

Tags: SQL, SQL Authority, SQL Query, SQL Server, SQLAuthority News, T-SQL, technology, SQL T-Shirt

SQL SERVER - 2005 -Track Down Active Transactions Using T-SQL — 8 comments

pinaldave wrote 2 days ago: Just a day ago, I was wondering how many active transaction are currently in my database. I found fo … more »

Tags: technology, SQL Server, SQL, SQL Query, SQL Authority, Author Pinal, T-SQL, SQL Scripts, SQL Transactions

SQL SERVER - Introduction to Log Viewer — 2 comments

pinaldave wrote 3 days ago: SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQ … more »

Tags: Author Pinal, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, T-SQL, technology, Log Viewer

SQL SERVER - FIX - ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

pinaldave wrote 5 days ago: ERROR : 9004 An error occurred while processing the log for database. If possible, restore from back … more »

Tags: SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Query, SQL Server, T-SQL, technology

SQLAuthority Author Visit - Ahmedabad SQL Server User Group Meeting - July 19 2008 — 3 comments

pinaldave wrote 5 days ago: Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular amo … more »

Tags: Best Practices, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL User Group, SQLAuthority Visit, T-SQL

SQL Server - Fix - Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

pinaldave wrote 1 week ago: If you face following error the solution of this is very simple. Error : 9692 The _MSG protocol tran … more »

Tags: SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, T-SQL, technology, Service Broker

SQL SERVER - Introduction to Service Broker — 2 comments

pinaldave wrote 1 week ago: Service Broker is message queuing for SQL Server. It is used for sending emails and through Database … more »

Tags: Author Pinal, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, T-SQL, technology, Service Broker

SQLAuthority News - Updated My Personal Book Mark Pages — 1 comment

pinaldave wrote 1 week ago: It has been long time since I have updated my personal book mark list. I have just refreshed it. You … more »

Tags: Database, dba, SQL, SQL Authority, SQL Query, SQL Server, SQLAuthority News, T-SQL, technology

SQLAuthority News - Ahmedabad SQL Server Usergroup Meeting — 4 comments

pinaldave wrote 1 week ago: I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking sessio … more »

Tags: SQL, SQL Authority, SQL Query, SQL Server, SQL User Group, SQLAuthority Visit, T-SQL, technology

SQL SERVER - Readers Contribution to Site - Simple Example of Cursor — 1 comment

pinaldave wrote 1 week ago: eaders are very important to me. Without their active participation this site would not be the commu … more »

Tags: SQL, SQL Authority, SQL Cursor, SQL Query, SQL Scripts, SQL Server, T-SQL, technology

SQL SERVER - Deferred Name Resolution — 4 comments

pinaldave wrote 1 week ago: One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is i … more »

Tags: Author Pinal, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, T-SQL, technology

SQL SERVER - 2008 - Introduction to SPARSE Columns - Part 2 — 1 comment

pinaldave wrote 1 week ago: Previously I wrote about SQL SERVER - 2008 - Introduction to SPARSE Columns. Let us understand the c … more »

Tags: Author Pinal, SQL, SQL Authority, SQL Data Storage, SQL Performance, SQL Query, SQL Scripts, SQL Server, T-SQL

SQL SERVER - SP_CONFIGURE - Displays or Changes Global Configuration Settings

pinaldave wrote 1 week ago: It is very good to know our server and its feature which are available for configurations. SQL Serve … more »

Tags: Author Pinal, SQL, SQL Authority, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, T-SQL

SQL SERVER - 2005 - Two Important Security Update — 3 comments

pinaldave wrote 2 weeks ago: If you are using SQL Server 2005, following two are very important security updates not to be missed … more »

Tags: SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Security, SQL Server, T-SQL, technology

SQL SERVER - 2008 - Introduction to SPARSE Columns — 3 comments

pinaldave wrote 2 weeks ago: I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup M … more »