| 2500 |
May 16, 2013 |
SQLAuthority News – 2500 Blog Posts, 2 Million Views per month, 62 Million Total Views |
| 2499 |
May 15, 2013 |
SQL SERVER – SQL Puzzle of SET ANSI_NULL – Win USD 50 worth Amazon Gift Cards and Bubble Copter R/C |
| 2498 |
May 14, 2013 |
SQL SERVER – How to use xp_sscanf in Real World Scenario? |
| 2497 |
May 13, 2013 |
SQL SERVER – Puzzle and Answer – REPLICATE over 8000 Characters |
| 2496 |
May 12, 2013 |
SQL SERVER – Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards |
| 2495 |
May 11, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #028 |
| 2494 |
May 10, 2013 |
SQL SERVER – Adding Column Defaulting to Current Datetime in Table |
| 2493 |
May 09, 2013 |
SQL SERVER – A New Approach to Scale .NET Applications |
| 2492 |
May 08, 2013 |
SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051 |
| 2491 |
May 07, 2013 |
SQLAuthority News – Sharding or No Sharding of Database – Working on my Weekend Project |
| 2490 |
May 06, 2013 |
SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP |
| 2489 |
May 05, 2013 |
SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation |
| 2488 |
May 04, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #027 |
| 2487 |
May 03, 2013 |
SQL SERVER – DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement |
| 2486 |
May 02, 2013 |
SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore |
| 2485 |
May 01, 2013 |
SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course |
| 2484 |
Apr 30, 2013 |
SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement |
| 2483 |
Apr 29, 2013 |
SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database |
| 2482 |
Apr 28, 2013 |
SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop |
| 2481 |
Apr 27, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #026 |
| 2480 |
Apr 26, 2013 |
SQL SERVER – UNION ALL and UNION are Different Operation |
| 2479 |
Apr 25, 2013 |
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2 |
| 2478 |
Apr 24, 2013 |
SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050 |
| 2477 |
Apr 23, 2013 |
SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script |
| 2476 |
Apr 22, 2013 |
SQL SERVER – Discussion – Scale-up vs Scale-out Architectures |
| 2475 |
Apr 22, 2013 |
SQLAuthority News – Webinar SQL Server Locking and Concurrency by Rick Morelan |
| 2474 |
Apr 21, 2013 |
SQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013 |
| 2473 |
Apr 20, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #025 |
| 2472 |
Apr 19, 2013 |
SQL SERVER – How to Begin with VMware – Introduction to Virtualization |
| 2471 |
Apr 18, 2013 |
SQL SERVER – Using SSIS to Import CSV File into Salesforce Online Database with dotConnect for Salesforce from Devart |
| 2470 |
Apr 17, 2013 |
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049 |
| 2469 |
Apr 16, 2013 |
SQL SERVER – Get High Availability with SQL Server 2012 |
| 2468 |
Apr 15, 2013 |
SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey |
| 2467 |
Apr 14, 2013 |
SQL SERVER – Tricks for Row Offset and Paging in Various Versions of SQL Server |
| 2466 |
Apr 13, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #024 |
| 2465 |
Apr 12, 2013 |
SQLAuthority News – HP Project Moonshot Interchangeable and Interlockable Servers with Elastically Scale NuoDB |
| 2464 |
Apr 11, 2013 |
SQLAuthority News – Koenig Solutions Invests into World’s Largest IT Training Center |
| 2463 |
Apr 10, 2013 |
SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048 |
| 2462 |
Apr 09, 2013 |
SQL SERVER – Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. |
| 2461 |
Apr 08, 2013 |
SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. |
| 2460 |
Apr 07, 2013 |
SQL SERVER – Pass One Stored Procedure’s Result as Another Stored Procedure’s Parameter |
| 2459 |
Apr 06, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #023 |
| 2458 |
Apr 05, 2013 |
SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick |
| 2457 |
Apr 04, 2013 |
SQLAuthority Contests – Get 50 Amazon Gift Cards – Experience NuoDB Starlings 1.0.2 |
| 2456 |
Apr 03, 2013 |
SQL SERVER – Resolve Cannot Resolve Collation Conflict Error – SQL in Sixty Seconds #047 |
| 2455 |
Apr 02, 2013 |
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 6 |
| 2454 |
Apr 01, 2013 |
SQL SERVER – Three Efficiency Tools for SQL Server from Devart |
| 2453 |
Mar 31, 2013 |
SQL SERVER – Three Important Documentation to download – Standards Support, Protocol, Data Portability |
| 2452 |
Mar 30, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #022 |
| 2451 |
Mar 29, 2013 |
SQL SERVER – XML Data Type- SQL Queries 2012 Joes 2 Pros Volume 5 – XML Querying Techniques for SQL Server 2012 |
| 2450 |
Mar 28, 2013 |
SQL SERVER – Executing Dynamic SQL – SQL Queries 2012 Joes 2 Pros Volume 4 – Query Programming Objects for SQL Server 2012 |
| 2449 |
Mar 27, 2013 |
SQL SERVER – Introduction to GUIDs – SQL Queries 2012 Joes 2 Pros Volume 3 – Advanced Query Tools and Techniques for SQL Server 2012 |
| 2448 |
Mar 26, 2013 |
SQL SERVER – Identity Fields Review – SQL Queries 2012 Joes 2 Pros Volume 2 – The SQL Query Techniques Tutorial for SQL Server 2012 |
| 2447 |
Mar 25, 2013 |
SQL SERVER – Query Writing Strategy – SQL Queries 2012 Joes 2 Pros Volume 1 – The SQL Queries 2012 Hands-On Tutorial for Beginners |
| 2446 |
Mar 24, 2013 |
SQLAuthority News – Whitepaper – Plan Caching and Recompilation in SQL Server 2012 |
| 2445 |
Mar 23, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #021 |
| 2444 |
Mar 22, 2013 |
SQL SERVER – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer |
| 2443 |
Mar 21, 2013 |
SQL SERVER – Identify Last User Access of Table using T-SQL Script |
| 2442 |
Mar 20, 2013 |
SQLAuthority News – How to Avoid Procrastination – Professional Development #001 – Video |
| 2441 |
Mar 19, 2013 |
SQL SERVER – TechEd India 2013 Sessions and Relevent Pluralsight Courses |
| 2440 |
Mar 18, 2013 |
SQLAuthority News – Presenting Two Technology Sessions at TechEd India 2013 – Today and Tomorrow |
| 2439 |
Mar 17, 2013 |
SQLAuthority News – Excellent Learning Experience at SQLskills Immersion Events |
| 2438 |
Mar 16, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #020 |
| 2437 |
Mar 15, 2013 |
SQLAuthority News – Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore |
| 2436 |
Mar 14, 2013 |
SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013 |
| 2435 |
Mar 13, 2013 |
SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video |
| 2434 |
Mar 12, 2013 |
SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek |
| 2433 |
Mar 11, 2013 |
SQL SERVER – How to Add Column at Specific Location in Table |
| 2432 |
Mar 10, 2013 |
SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework |
| 2431 |
Mar 09, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #019 |
| 2430 |
Mar 08, 2013 |
SQL SERVER – Tricky Question – What is the Default Size of the Database |
| 2429 |
Mar 07, 2013 |
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function |
| 2428 |
Mar 06, 2013 |
SQL SERVER – Watch Four Efficiency Tricks in SQL Server In Sixty Seconds – Subscribe for SQL Learning Videos |
| 2427 |
Mar 05, 2013 |
SQL SERVER – Exporting Query Results to CSV using SQLCMD |
| 2426 |
Mar 04, 2013 |
SQL SERVER – SSMS does NOT Print NULL Values |
| 2425 |
Mar 03, 2013 |
SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples |
| 2424 |
Mar 02, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #018 |
| 2423 |
Mar 01, 2013 |
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 5 |
| 2422 |
Feb 28, 2013 |
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 4 |
| 2421 |
Feb 27, 2013 |
SQL SERVER – Cycle Clipboard Ring in SSMS – SQL in Sixty Seconds #045 – Video |
| 2420 |
Feb 27, 2013 |
SQL SERVER – Beginning SQL 2012 – Spatial Unions and Collections – Abstract from Joes 2 Pros Volume 3 |
| 2419 |
Feb 26, 2013 |
SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2 |
| 2418 |
Feb 25, 2013 |
SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1 |
| 2417 |
Feb 24, 2013 |
SQL SERVER – Cumulative Update Released in February 2013 for SQL Server Editions |
| 2416 |
Feb 23, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #017 |
| 2415 |
Feb 22, 2013 |
SQL SERVER – T-SQL Script to Keep CPU Busy |
| 2414 |
Feb 21, 2013 |
SQL SERVER – Shortcut to SELECT only 1 Row from Table |
| 2413 |
Feb 20, 2013 |
SQL SERVER – Restore SQL Database using SSMS – SQL in Sixty Seconds #044 – Video |
| 2412 |
Feb 19, 2013 |
SQLAuthority News – Introduction to ColdFusion – Video Tutorial on Pluralsight |
| 2411 |
Feb 18, 2013 |
SQLAuthority News – NuoDB Announces Webinar Series To Demystify Cloud Data Management |
| 2410 |
Feb 17, 2013 |
SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed |
| 2409 |
Feb 16, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #016 |
| 2408 |
Feb 15, 2013 |
SQLAuthority News – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013 |
| 2407 |
Feb 14, 2013 |
SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server |
| 2406 |
Feb 13, 2013 |
SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video |
| 2405 |
Feb 12, 2013 |
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5 |
| 2404 |
Feb 11, 2013 |
SQL SERVER – What is Semantics Model – A Simple Explanation |
| 2403 |
Feb 10, 2013 |
SQL SERVER – Primary Key and NonClustered Index in Simple Words |
| 2402 |
Feb 09, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #015 |
| 2401 |
Feb 08, 2013 |
SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD |
| 2400 |
Feb 07, 2013 |
SQLAuthority News – Delhi Flash Mob and Women Safety – 2400th Blog Post – A Milestone |
| 2399 |
Feb 06, 2013 |
SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video |
| 2398 |
Feb 05, 2013 |
SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name |
| 2397 |
Feb 04, 2013 |
SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors |
| 2396 |
Feb 03, 2013 |
SQLAuthority News – Reset Messaging (SMS/Text) Icon Count in Android Jelly Bean |
| 2395 |
Feb 02, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #014 |
| 2394 |
Feb 01, 2013 |
SQL SERVER – Difference Between NOLOCK and NOWAIT Hints |
| 2393 |
Jan 31, 2013 |
SQL SERVER – Significance of Table Input Parameter to Stored Procedure – Guest Post by Vikas Munjal – Koenig Solutions |
| 2392 |
Jan 30, 2013 |
SQL SERVER – Autocomplete and Code Formatting Tool – SQL in Sixty Seconds #041 – Video |
| 2391 |
Jan 29, 2013 |
SQL SERVER – Contest to Win Amazon Card – Experience Cloud Data Management System (CDMS) and NuoDB |
| 2390 |
Jan 28, 2013 |
SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query |
| 2389 |
Jan 27, 2013 |
SQLAuthority News – Developing Multi-tenant Applications for the Cloud, 3rd Edition – Book Download |
| 2388 |
Jan 26, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #013 |
| 2387 |
Jan 25, 2013 |
SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query |
| 2386 |
Jan 24, 2013 |
SQL SERVER – How to Use Instead of Trigger – Guest Post by Vikas Munjal – Koenig Solutions |
| 2385 |
Jan 23, 2013 |
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video |
| 2384 |
Jan 22, 2013 |
SQLAuthority News – Great Experience at SharePoint Conference Singapore 2013 |
| 2383 |
Jan 21, 2013 |
SQL SERVER – Best Practices to Store the SQL Server Backups |
| 2382 |
Jan 20, 2013 |
SQLAuthority News – Download Whitepaper – Introducing the BI Semantic Model in Microsoft SQL Server 2012 |
| 2381 |
Jan 19, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #012 |
| 2380 |
Jan 18, 2013 |
SQL SERVER – A List of Various SQL Server RTM and Service Pack Number |
| 2379 |
Jan 17, 2013 |
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4 |
| 2378 |
Jan 16, 2013 |
SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video |
| 2377 |
Jan 15, 2013 |
SQL SERVER – Introduction of Showplan Warning |
| 2376 |
Jan 14, 2013 |
SQLAuthority News – Attending SQLskills Training in February 2013 |
| 2375 |
Jan 13, 2013 |
SQLAuthority News – Download Whitepaper – SSIS Operational and Tuning Guide – SSIS for Azure and Hybrid Data Movement – Leveraging a Hadoop cluster from SSIS |
| 2374 |
Jan 12, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #011 |
| 2373 |
Jan 11, 2013 |
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 3 |
| 2372 |
Jan 10, 2013 |
SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore |
| 2371 |
Jan 09, 2013 |
SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani |
| 2370 |
Jan 08, 2013 |
SQL Server – Using SSMS Commandline Parameters – Guest Post by Vinod Kumar M |
| 2369 |
Jan 08, 2013 |
SQLAuthority News – Register for NuoDB the Elastically Scalable, SQL/ACID Database |
| 2368 |
Jan 07, 2013 |
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2 |
| 2367 |
Jan 06, 2013 |
SQLAuthority News – Download Whitepaper – Cleanse and Match Master Data by Using EIM |
| 2366 |
Jan 05, 2013 |
SQL SERVER – Weekly Series – Memory Lane – #010 |
| 2365 |
Jan 04, 2013 |
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1 |
| 2364 |
Jan 03, 2013 |
SQLAuthority News – Year 2012 in Review – Perspective of Blog |
| 2363 |
Jan 02, 2013 |
SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video |
| 2362 |
Jan 01, 2013 |
SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself |
| 2361 |
Dec 31, 2012 |
SQLAuthority News – Last Post of Year 2012 |
| 2360 |
Dec 30, 2012 |
SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard) |
| 2359 |
Dec 29, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #009 |
| 2358 |
Dec 28, 2012 |
SQLAuthority News – NuoDB RC2 Available to Download – General Availability in Near Future |
| 2357 |
Dec 27, 2012 |
SQL SERVER – Creating Database with Different Collation on Server |
| 2356 |
Dec 26, 2012 |
SQL SERVER – Take Database Backup using SSMS – SQL in Sixty Seconds #037 – Video |
| 2355 |
Dec 25, 2012 |
SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions |
| 2354 |
Dec 24, 2012 |
SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup. |
| 2353 |
Dec 23, 2012 |
SQL SERVER – What is Hekaton? – Simple Words Explanation |
| 2352 |
Dec 22, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #008 |
| 2351 |
Dec 21, 2012 |
SQLAuthority News – Chrome Browser – Personal Technology |
| 2350 |
Dec 20, 2012 |
SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server |
| 2349 |
Dec 19, 2012 |
SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video |
| 2348 |
Dec 18, 2012 |
SQL SERVER – Select the Most Optimal Backup Methods for Server |
| 2347 |
Dec 17, 2012 |
SQL SERVER – Auto Complete and Format T-SQL Code – Devart SQL Complete |
| 2346 |
Dec 16, 2012 |
SQLAuthority News – First SQL Bangalore Event Report – Nov 24, 2012 – SQL Server User Group Bangalore |
| 2345 |
Dec 15, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #007 |
| 2344 |
Dec 14, 2012 |
SQL Contest – Result of Cartoon Contest |
| 2343 |
Dec 13, 2012 |
SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore |
| 2342 |
Dec 12, 2012 |
SQL SERVER – Inviting Ideas for SQL in Sixty Seconds – 12/12/12 |
| 2341 |
Dec 11, 2012 |
SQL SERVER – Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve |
| 2340 |
Dec 10, 2012 |
SQL SERVER – Get 2 of My Books FREE at Koenig Tech Day – Where Technologies Converge! |
| 2339 |
Dec 09, 2012 |
SQL Authority News – Download SQL Server Data Type Conversion Chart |
| 2338 |
Dec 08, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #006 |
| 2337 |
Dec 07, 2012 |
SQLAuthority News – Technology and Online Learning – Personal Technology Tip |
| 2336 |
Dec 06, 2012 |
SQL SERVER – Caption the Cartoon Contest – Last 2 Days |
| 2335 |
Dec 05, 2012 |
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video |
| 2334 |
Dec 04, 2012 |
SQL SERVER – Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator |
| 2333 |
Dec 03, 2012 |
SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ’80040e07′ or Microsoft SQL Native Client error ’80040e07′ |
| 2332 |
Dec 02, 2012 |
SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies |
| 2331 |
Dec 01, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #005 |
| 2330 |
Nov 30, 2012 |
SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL |
| 2329 |
Nov 29, 2012 |
SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back |
| 2328 |
Nov 28, 2012 |
SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video |
| 2327 |
Nov 27, 2012 |
SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database |
| 2326 |
Nov 26, 2012 |
SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3 |
| 2325 |
Nov 25, 2012 |
SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012 |
| 2324 |
Nov 24, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #004 |
| 2323 |
Nov 23, 2012 |
SQLAuthority News – Android Efficiency Tips and Tricks – Personal Technology Tip |
| 2322 |
Nov 22, 2012 |
SQL SERVER – Removing Leading Zeros From Column in Table – Part 2 |
| 2321 |
Nov 21, 2012 |
SQL SERVER – Display Datetime in Specific Format – SQL in Sixty Seconds #033 – Video |
| 2320 |
Nov 20, 2012 |
SQL SERVER – Using RAND() in User Defined Functions (UDF) |
| 2319 |
Nov 19, 2012 |
SQL SERVER – Removing Leading Zeros From Column in Table |
| 2318 |
Nov 18, 2012 |
SQLAuthority News – Microsoft SQL Server 2012 Service Pack 1 Released (SP1) |
| 2317 |
Nov 17, 2012 |
SQL SERVER – Weekly Series – Memory Lane – #003 |
| 2316 |
Nov 16, 2012 |
SQL SERVER – Retrieving Random Rows from Table Using NEWID() |
| 2315 |
Nov 15, 2012 |
SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar |
| 2314 |
Nov 14, 2012 |
SQL SERVER – Rename Columnname or Tablename – SQL in Sixty Seconds #032 – Video |
| 2313 |
Nov 13, 2012 |
SQLAuthority News – Happy Deepavali and Happy New Year |
| 2312 |
Nov 12, 2012 |
SQL SERVER – Get Free Books on While Learning SQL Server 2012 Error Handling |
| 2311 |
Nov 11, 2012 |
SQL SERVER – Changing Default Installation Path for SQL Server |
| 2310 |
Nov 10, 2012 |
SQL SERVER – Beginning New Weekly Series – Memory Lane – #002 |
| 2309 |
Nov 09, 2012 |
SQLAuthority News – #SQLPASS 2012 Book Signing Photos |
| 2308 |
Nov 08, 2012 |
SQLAuthority News – Learning, Community and Book Signing at #SQLPASS 2012 |
| 2307 |
Nov 07, 2012 |
SQLAuthority News – 2 New Books – FREE Books and Book Signing at #SQLPASS 2012 |
| 2306 |
Nov 06, 2012 |
SQLAuthority News – #SQLPASS 2012 Schedule – Where can You Find Me |
| 2305 |
Nov 05, 2012 |
SQLAuthority News – #SQLPASS 2012 Seattle Update – Memorylane 2009, 2010, 2011 |
| 2304 |
Nov 04, 2012 |
SQLAuthority News – Why I am Going to Attend #SQLPASS Summit 2012 – Seattle |
| 2303 |
Nov 03, 2012 |
SQL SERVER – Beginning New Weekly Series – Memory Lane – #001 |
| 2302 |
Nov 02, 2012 |
SQL SERVER – Function to Round Up Time to Nearest Minutes Interval |
| 2301 |
Nov 01, 2012 |
SQLAuthority News – 6th Anniversary and 50 Million Views and Over 2300 Blog Posts – Thank You Thank You |
| 2300 |
Oct 31, 2012 |
SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video |
| 2299 |
Oct 30, 2012 |
SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL |
| 2298 |
Oct 29, 2012 |
SQLAuthority News – Windows Efficiency Tricks and Tips – Personal Technology Tip |
| 2297 |
Oct 28, 2012 |
SQL SERVER – Move Database Files MDF and LDF to Another Location |
| 2296 |
Oct 27, 2012 |
SQL SERVER – Storing Variable Values in Temporary Array or Temporary List |
| 2295 |
Oct 26, 2012 |
SQL SERVER – Introduction to Big Data – Guest Post |
| 2294 |
Oct 25, 2012 |
SQL SERVER – Last Two Days to Get FREE Book – Joes 2 Pros Certification 70-433 |
| 2293 |
Oct 24, 2012 |
SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video |
| 2292 |
Oct 23, 2012 |
SQL SERVER – Order By Numeric Values Formatted as String |
| 2291 |
Oct 22, 2012 |
SQL SERVER – Vacation, Travel and Study – A New Concept |
| 2290 |
Oct 21, 2012 |
SQLAuthority News – Windows Azure Training Kit Updated October 2012 |
| 2289 |
Oct 20, 2012 |
SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post |
| 2288 |
Oct 19, 2012 |
SQLAuthority News – Storing Data and Files in Cloud – Dropbox – Personal Technology Tip |
| 2287 |
Oct 18, 2012 |
SQL SERVER – Finding Different ColumnName From Almost Identitical Tables |
| 2286 |
Oct 17, 2012 |
SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 2 of 2 |
| 2285 |
Oct 16, 2012 |
SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 1 of 2 |
| 2284 |
Oct 15, 2012 |
SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit |
| 2283 |
Oct 14, 2012 |
SQL SERVER – Find First Non-Numeric Character from String |
| 2282 |
Oct 13, 2012 |
SQL SERVER – 2012 – List All The Column With Specific Data Types in Database |
| 2281 |
Oct 12, 2012 |
SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market |
| 2280 |
Oct 11, 2012 |
SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB |
| 2279 |
Oct 10, 2012 |
SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #029 – Video |
| 2278 |
Oct 09, 2012 |
SQL SERVER – Identify Numbers of Non Clustered Index on Tables for Entire Database |
| 2277 |
Oct 09, 2012 |
SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan |
| 2276 |
Oct 08, 2012 |
SQL SERVER – Recover the Accidentally Renamed Table |
| 2275 |
Oct 07, 2012 |
SQLAuthority News – Download Whitepaper – SQL Server Analysis Services to Hive |
| 2274 |
Oct 06, 2012 |
SQL SERVER – Manage Help Settings – CTRL + ALT + F1 |
| 2273 |
Oct 05, 2012 |
SQL SERVER – 3 Online SQL Courses at Pluralsight and Free Learning Resources |
| 2272 |
Oct 04, 2012 |
SQL SERVER – Importance of User Without Login – T-SQL Demo Script |
| 2271 |
Oct 03, 2012 |
SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video |
| 2270 |
Oct 02, 2012 |
SQL SERVER – Solution – 2 T-SQL Puzzles – Display Star and Shortest Code to Display 1 |
| 2269 |
Oct 01, 2012 |
SQLAuthority News – Follow up on – Replace a Column Name in Multiple Stored Procedure all together |
| 2268 |
Sep 30, 2012 |
SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS |
| 2267 |
Sep 29, 2012 |
SQL SERVER – Importance of User Without Login |
| 2266 |
Sep 28, 2012 |
SQL SERVER – A Picture is Worth a Thousand Words – A Collection of Inspiring and Funny Posts by Vinod Kumar |
| 2265 |
Sep 27, 2012 |
SQL SERVER – Not Possible – Delete From Multiple Table – Update Multiple Table in Single Statement |
| 2264 |
Sep 26, 2012 |
SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video |
| 2263 |
Sep 25, 2012 |
SQL SERVER – Basic Calculation and PEMDAS Order of Operation |
| 2262 |
Sep 24, 2012 |
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet |
| 2261 |
Sep 23, 2012 |
SQLAuthority News – Download SQL Server 2012 SP1 CTP4 |
| 2260 |
Sep 22, 2012 |
SQL SERVER – Validating Unique Columnname Across Whole Database |
| 2259 |
Sep 21, 2012 |
SQL SERVER – Replace a Column Name in Multiple Stored Procedure all together |
| 2258 |
Sep 20, 2012 |
SQL SERVER – 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes |
| 2257 |
Sep 19, 2012 |
SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video |
| 2256 |
Sep 18, 2012 |
SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer |
| 2255 |
Sep 17, 2012 |
SQL SERVER – Guest Post by Sandip Pani – SQL Server Statistics Name and Index Creation |
| 2254 |
Sep 16, 2012 |
SQLAuthority News – Download Whitepaper – Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts |
| 2253 |
Sep 15, 2012 |
SQL SERVER – Download Microsoft SQL Server Compact 4.0 SP1 |
| 2252 |
Sep 14, 2012 |
SQL SERVER – Grouping by Multiple Columns to Single Column as A String |
| 2251 |
Sep 13, 2012 |
SQL SERVER – Core Concepts – Elasticity, Scalability and ACID Properties – Exploring NuoDB an Elastically Scalable Database System |
| 2250 |
Sep 12, 2012 |
SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video |
| 2249 |
Sep 11, 2012 |
SQL SERVER – Why Do We Need Master Data Management – Importance and Significance of Master Data Management (MDM) |
| 2248 |
Sep 10, 2012 |
SQL SERVER – Why Do We Need Data Quality Services – Importance and Significance of Data Quality Services (DQS) |
| 2247 |
Sep 09, 2012 |
SQL SERVER – Configuring Interactive Cleansing Suggestion Min Score for Suggestions in Data Quality Services (DQS) – Sensitivity of Suggestion |
| 2246 |
Sep 08, 2012 |
SQL SERVER – Unable to DELETE Project in Data Quality Projects (DQS) |
| 2245 |
Sep 07, 2012 |
SQL SERVER – Fun Post – Connecting Same SQL Server using Different Methods |
| 2244 |
Sep 06, 2012 |
SQL SERVER – FIX ERROR – Cannot connect to . Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452) |
| 2243 |
Sep 05, 2012 |
SQLAuthority News – A Quick Note on @Pluralsight Video – Call Me Maybe Developer Way |
| 2242 |
Sep 04, 2012 |
SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS |
| 2241 |
Sep 03, 2012 |
SQL SERVER – DQS Error – Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo |
| 2240 |
Sep 02, 2012 |
SQLAuthority News – Weekend Experiment with NuoDB – Points to Pondor and Whitepaper |
| 2239 |
Sep 01, 2012 |
SQLAuthority News – Memories at Anniversary of SQL Wait Stats Book |
| 2238 |
Aug 31, 2012 |
SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’ |
| 2237 |
Aug 30, 2012 |
SQL SERVER – Beginning of SQL Server Architecture – Terminology – Guest Post |
| 2236 |
Aug 29, 2012 |
SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video |
| 2235 |
Aug 28, 2012 |
SQL SERVER – A Brief Note on SET TEXTSIZE |
| 2234 |
Aug 27, 2012 |
SQL SERVER – Answer – Value of Identity Column after TRUNCATE command |
| 2233 |
Aug 26, 2012 |
SQL SERVER – Download PSSDIAG Data Collection Utility |
| 2232 |
Aug 25, 2012 |
SQLAuthority News – Featuring in Call Me Maybe The Developer Way – Pluralsight Video |
| 2231 |
Aug 24, 2012 |
SQL SERVER – DELETE, TRUNCATE and RESEED Identity |
| 2230 |
Aug 23, 2012 |
SQL SERVER – Reseting Identity Values for All Tables |
| 2229 |
Aug 22, 2012 |
SQL SERVER – Color Coding SQL Server Management Studio Status Bar – SQL in Sixty Seconds #023 – Video |
| 2228 |
Aug 21, 2012 |
SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012 |
| 2227 |
Aug 20, 2012 |
SQL SERVER – Winners – Contest Win Joes 2 Pros Combo (USD 198) |
| 2226 |
Aug 19, 2012 |
SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users |
| 2225 |
Aug 18, 2012 |
SQLAuthority News – Presented at Bangalore DevCon August 4, 2012 |
| 2224 |
Aug 17, 2012 |
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2 |
| 2223 |
Aug 16, 2012 |
SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2 |
| 2222 |
Aug 15, 2012 |
SQLAuthority News – Technical Review of Learning at Koenig Solutions |
| 2221 |
Aug 14, 2012 |
SQLAuthority News – Learning Trip – Traveling to Learn SQL Server |
| 2220 |
Aug 13, 2012 |
SQLAuthority News – Getting Ready to Learn SQL Server |
| 2219 |
Aug 12, 2012 |
SQL SERVER – ERROR: FIX using Compatibility Level – Database diagram support objects cannot be installed because this database does not have a valid owner – Part 2 |
| 2218 |
Aug 11, 2012 |
SQL SERVER – Contest – Summary of 5 Day and Additional Information |
| 2217 |
Aug 10, 2012 |
SQL SERVER – Understanding XML – Contest Win Joes 2 Pros Combo (USD 198) – Day 5 of 5 |
| 2216 |
Aug 09, 2012 |
SQL SERVER – Expanding Views – Contest Win Joes 2 Pros Combo (USD 198) – Day 4 of 5 |
| 2215 |
Aug 08, 2012 |
SQL SERVER – Clustered Index and Primary Key – Contest Win Joes 2 Pros Combo (USD 198) – Day 3 of 5 |
| 2214 |
Aug 07, 2012 |
SQL SERVER – Identity Fields – Contest Win Joes 2 Pros Combo (USD 198) – Day 2 of 5 |
| 2213 |
Aug 06, 2012 |
SQL SERVER – Query Hint – Contest Win Joes 2 Pros Combo (USD 198) – Day 1 of 5 |
| 2212 |
Aug 05, 2012 |
SQLAuthority News – Microsoft Whitepaper – AlwaysOn Solution Guide: Offloading Read-Only Workloads to Secondary Replicas |
| 2211 |
Aug 04, 2012 |
SQL SERVER – Fix: Error: 8117: Operand data type bit is invalid for sum operator |
| 2210 |
Aug 03, 2012 |
SQLAuthority News – Learning Never Ends – Becoming Student Again |
| 2209 |
Aug 02, 2012 |
SQL SERVER – Beginning of SQL Server Security – Guest Post |
| 2208 |
Aug 01, 2012 |
SQL SERVER – 5 Videos from Joes 2 Pros Series Exam Prep Series 70-433 – SQL in Sixty Seconds |
| 2207 |
Aug 01, 2012 |
SQL SERVER – Follow up on Beginning NuoDB – Who will Benefit and How to Start – Part 2 |
| 2206 |
Jul 31, 2012 |
SQL SERVER – Beginning NuoDB – Who will Benefit and How to Start |
| 2205 |
Jul 30, 2012 |
SQLAuthority News – An Year Older and 3 SQL Server Books and 3 Video Courses – 33 |
| 2204 |
Jul 29, 2012 |
SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2 |
| 2203 |
Jul 28, 2012 |
SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME() |
| 2202 |
Jul 27, 2012 |
SQL SERVER – Query to Get Unique Distinct Data Based on Condition – Eliminate Duplicate Data from Resultset |
| 2201 |
Jul 26, 2012 |
SQL SERVER – Answer – How to Convert Hex to Decimal or INT |
| 2200 |
Jul 25, 2012 |
SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video |
| 2199 |
Jul 24, 2012 |
SQLAuthority Guest Post – Lessons from Life and Work – Power in the Workplace – Srini Chandra (Author of 3 Lives, in search of bliss) |
| 2198 |
Jul 23, 2012 |
SQL SERVER – Observation of Top with Index and Order of Resultset |
| 2197 |
Jul 22, 2012 |
SQLAuthority News – 2 SQL Server Documentations Updates |
| 2196 |
Jul 21, 2012 |
SQL SERVER – Download SQL Server 2012 Developer Training Kit – Update July 2012 |
| 2195 |
Jul 20, 2012 |
SQL SERVER – INFORMATION_SCHEMA.COLUMNS and Value Character Maximum Length -1 |
| 2194 |
Jul 19, 2012 |
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2 |
| 2193 |
Jul 18, 2012 |
SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video |
| 2192 |
Jul 17, 2012 |
SQLAuthority Guest Post – Lessons from Life – Practice Let Go – Srini Chandra (Author of 3 Lives, in search of bliss) |
| 2191 |
Jul 16, 2012 |
SQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage |
| 2190 |
Jul 15, 2012 |
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name |
| 2189 |
Jul 14, 2012 |
SQL SERVER – Example of Width Sensitive and Width Insensitive Collation |
| 2188 |
Jul 13, 2012 |
SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+] |
| 2187 |
Jul 12, 2012 |
SQL SERVER – Effect of Case Sensitive Collation on Resultset |
| 2186 |
Jul 11, 2012 |
SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video |
| 2185 |
Jul 10, 2012 |
SQLAuthority Guest Post – Lessons from Life and Work by Srini Chandra (Author of 3 Lives, in search of bliss) |
| 2184 |
Jul 09, 2012 |
SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always |
| 2183 |
Jul 08, 2012 |
SQLAuthority News – 2 Whitepapers Announced – AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution |
| 2182 |
Jul 07, 2012 |
SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis |
| 2181 |
Jul 06, 2012 |
SQL SERVER – NTFS File System Performance for SQL Server |
| 2180 |
Jul 05, 2012 |
SQL SERVER – Retrieve SQL Server Installation Date Time |
| 2179 |
Jul 04, 2012 |
SQL SERVER – Tricks to Comment T-SQL in SSMS – SQL in Sixty Seconds #019 – Video |
| 2178 |
Jul 03, 2012 |
SQL SERVER – Monitoring SQL Server Database Transaction Log Space Growth – DBCC SQLPERF(logspace) – Puzzle for You |
| 2177 |
Jul 02, 2012 |
SQL SERVER – Weekend Project – Visiting Friend’s Company – Koenig Solutions |
| 2176 |
Jul 01, 2012 |
SQL SERVER – Discard Results After Query Execution – SSMS |
| 2175 |
Jun 30, 2012 |
SQL SERVER – Validating Spatial Object as NULL using IsNULL |
| 2174 |
Jun 29, 2012 |
SQL SERVER – Validating Spatial Object with IsValidDetailed Function |
| 2173 |
Jun 28, 2012 |
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred |
| 2172 |
Jun 27, 2012 |
SQL SERVER – Powershell – Importing CSV File Into Database – Video |
| 2171 |
Jun 26, 2012 |
SQL SERVER – Weekend Project – Experimenting with ACID Transactions, SQL Compliant, Elastically Scalable Database |
| 2170 |
Jun 25, 2012 |
SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS |
| 2169 |
Jun 24, 2012 |
SQL SERVER – Download SQL Server Product Documentation |
| 2168 |
Jun 23, 2012 |
SQL SERVER – Introduction to Function SIGN |
| 2167 |
Jun 22, 2012 |
SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY |
| 2166 |
Jun 21, 2012 |
SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode |
| 2165 |
Jun 20, 2012 |
SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video |
| 2164 |
Jun 19, 2012 |
SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue |
| 2163 |
Jun 18, 2012 |
SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables |
| 2162 |
Jun 17, 2012 |
SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS) |
| 2161 |
Jun 16, 2012 |
SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function |
| 2160 |
Jun 15, 2012 |
SQL SERVER – Free eBook Download – EPUB, MOBI, PDF Format |
| 2159 |
Jun 14, 2012 |
SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement |
| 2158 |
Jun 13, 2012 |
SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan |
| 2157 |
Jun 12, 2012 |
SQL SERVER – A Quick Look at Logging and Ideas around Logging |
| 2156 |
Jun 11, 2012 |
SQL SERVER – Developer Training Resources and Summary Roundup |
| 2155 |
Jun 10, 2012 |
SQL SERVER – Finding Size of a Columnstore Index Using DMVs |
| 2154 |
Jun 09, 2012 |
SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage |
| 2153 |
Jun 08, 2012 |
SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement |
| 2152 |
Jun 07, 2012 |
SQL SERVER – Load Generator – Free Tool From CodePlex |
| 2151 |
Jun 06, 2012 |
SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video |
| 2150 |
Jun 05, 2012 |
SQL SERVER – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier |
| 2149 |
Jun 04, 2012 |
SQL SERVER – Simple Example to Configure Resource Governor – Introduction to Resource Governor |
| 2148 |
Jun 03, 2012 |
SQL SERVER – Fix: Error: 147 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference |
| 2147 |
Jun 02, 2012 |
SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value |
| 2146 |
Jun 01, 2012 |
Developer Training – A Conclusive Summary- Part 5 |
| 2145 |
May 31, 2012 |
Developer Training – Various Options for Maximum Benefit – Part 4 |
| 2144 |
May 30, 2012 |
Developer Training – Difficult Questions and Alternative Perspective – Part 3 |
| 2143 |
May 29, 2012 |
Developer Training – Employee Morals and Ethics – Part 2 |
| 2142 |
May 28, 2012 |
Developer Training – Importance and Significance – Part 1 |
| 2141 |
May 27, 2012 |
SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value |
| 2140 |
May 26, 2012 |
SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value |
| 2139 |
May 25, 2012 |
SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value |
| 2138 |
May 24, 2012 |
SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117 |
| 2137 |
May 23, 2012 |
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video |
| 2136 |
May 22, 2012 |
SQL SERVER – SmallDateTime and Precision – A Continuous Confusion |
| 2135 |
May 21, 2012 |
SQL SERVER – Renaming Index – Index Naming Conventions |
| 2134 |
May 20, 2012 |
SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software |
| 2133 |
May 19, 2012 |
SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST |
| 2132 |
May 18, 2012 |
SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Post by Nakul Vachhrajani |
| 2131 |
May 17, 2012 |
SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB) |
| 2130 |
May 16, 2012 |
SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433 |
| 2129 |
May 15, 2012 |
SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME |
| 2128 |
May 14, 2012 |
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats |
| 2127 |
May 13, 2012 |
SQLAuthority News – Download Whitepaper – Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services |
| 2126 |
May 12, 2012 |
SQL SERVER – Developer Training Kit for SQL Server 2012 |
| 2125 |
May 11, 2012 |
SQL SERVER – Quiz and Video – Introduction to Discovering XML Data Type Methods |
| 2124 |
May 10, 2012 |
SQL SERVER – Quiz and Video – Introduction to SQL Error Actions |
| 2123 |
May 09, 2012 |
SQL SERVER – Quiz and Video – Introduction to Basics of a Query Hint |
| 2122 |
May 08, 2012 |
SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE |
| 2121 |
May 07, 2012 |
SQL SERVER – Quiz and Video – Introduction to SQL Server Security |
| 2120 |
May 06, 2012 |
SQL SERVER – Four Tutorial for SQL Server 2012 New Features |
| 2119 |
May 05, 2012 |
SQL SERVER – Migrate a SQL Server Reports from one server to another server |
| 2118 |
May 04, 2012 |
SQL SERVER – Identify Columnstore Index Usage from Execution Plan |
| 2117 |
May 03, 2012 |
SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function |
| 2116 |
May 02, 2012 |
SQL SERVER – Video – Step by Step Installation of SQL Server 2012 |
| 2115 |
May 01, 2012 |
SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani |
| 2114 |
Apr 30, 2012 |
SQL SERVER – A Brief Introduction to expressor Studio 3.6 |
| 2113 |
Apr 29, 2012 |
SQL SERVER – Microsoft Certification – SQL Server 2012 |
| 2112 |
Apr 28, 2012 |
SQLAuthority News – Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments – Part 1 |
| 2111 |
Apr 27, 2012 |
SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer |
| 2110 |
Apr 26, 2012 |
SQL SERVER – Introduction to SQL Error Actions – A Primer |
| 2109 |
Apr 25, 2012 |
SQL SERVER – Introduction to Basics of a Query Hint – A Primer |
| 2108 |
Apr 24, 2012 |
SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer |
| 2107 |
Apr 23, 2012 |
SQL SERVER – Introduction to SQL Server Security – A Primer |
| 2106 |
Apr 22, 2012 |
SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012 |
| 2105 |
Apr 21, 2012 |
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties |
| 2104 |
Apr 20, 2012 |
SQL SERVER – Performance Tuning – Part 2 of 2 – Analysis, Detection, Tuning and Optimizing |
| 2103 |
Apr 19, 2012 |
SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration |
| 2102 |
Apr 18, 2012 |
SQLAuthority News – Select the Best SQL in Sixty Seconds Episode – Help us Improve |
| 2101 |
Apr 17, 2012 |
SQL SERVER – Cheatsheet – Released for SQL Server 2012 Edition |
| 2100 |
Apr 16, 2012 |
SQLAuthority News – Presenting at Great Indian Developer Summit 2012 – SQL Server Misconception and Resolutions |
| 2099 |
Apr 15, 2012 |
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table |
| 2098 |
Apr 14, 2012 |
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment |
| 2097 |
Apr 13, 2012 |
SQLAuthority News – Social Media Series – LinkedIn and Professional Profile |
| 2096 |
Apr 12, 2012 |
SQLAuthority News – Social Media Series – YouTube and Movies |
| 2095 |
Apr 11, 2012 |
SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video |
| 2094 |
Apr 10, 2012 |
SQLAuthority News – Social Media Series – Facebook and Google+ |
| 2093 |
Apr 09, 2012 |
SQLAuthority News – Social Media Series – Twitter and Myself |
| 2092 |
Apr 08, 2012 |
SQLAuthority News – Download SQL Azure Labs Codename “Data Explorer” Client |
| 2091 |
Apr 07, 2012 |
SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module |
| 2090 |
Apr 06, 2012 |
SQLAuthority News – Reliving TechEd with Vinod Kumar at Bangalore User Groups |
| 2089 |
Apr 05, 2012 |
SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos |
| 2088 |
Apr 04, 2012 |
SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video |
| 2087 |
Apr 03, 2012 |
SQL SERVER – FIX: ERROR Msg 5169, Level 16: FILEGROWTH cannot be greater than MAXSIZE for file |
| 2086 |
Apr 02, 2012 |
SQL SERVER – Use ROLL UP Clause instead of COMPUTE BY |
| 2085 |
Apr 01, 2012 |
SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Day |
| 2084 |
Mar 31, 2012 |
SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012 |
| 2083 |
Mar 30, 2012 |
SQL SERVER – Online Index Rebuilding Index Improvement in SQL Server 2012 |
| 2082 |
Mar 29, 2012 |
SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX |
| 2081 |
Mar 28, 2012 |
SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video |
| 2080 |
Mar 27, 2012 |
SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS) |
| 2079 |
Mar 26, 2012 |
SQL SERVER – Partition Parallelism Support in expressor 3.6 |
| 2078 |
Mar 25, 2012 |
SQL SERVER – Download Free eBook – Introducing Microsoft SQL Server 2012 |
| 2077 |
Mar 24, 2012 |
SQL SERVER – Transcript of Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave |
| 2076 |
Mar 23, 2012 |
SQL SERVER – Using MAXDOP 1 for Single Processor Query – SQL in Sixty Seconds #008 – Video |
| 2075 |
Mar 22, 2012 |
SQL SERVER – #TechEdIn – Presenting Tomorrow on Speed Up! – Parallel Processes and Unparalleled Performance at TechEd India 2012 |
| 2074 |
Mar 21, 2012 |
SQL SERVER – Table Variables and Transactions – SQL in Sixty Seconds #007 – Video |
| 2073 |
Mar 20, 2012 |
SQL SERVER – #TechEdIn – Presenting Tomorrow on SQL Server Misconception and Resolution with Vinod Kumar at TechEd India 2012 |
| 2072 |
Mar 19, 2012 |
SQLAuthority News – #TechEDIn – TechEd India 2012 – Things to Do and Explore for SQL Enthusiast |
| 2071 |
Mar 18, 2012 |
SQL SERVER – Finding Shortest Distance between Two Shapes using Spatial Data Classes – Ramsetu or Adam’s Bridge |
| 2070 |
Mar 17, 2012 |
SQL SERVER – TechEd India 2012 – Content, Speakers and a Lots of Fun |
| 2069 |
Mar 16, 2012 |
SQL SERVER – SQL Server Misconceptions and Resolution – A Practical Perspective – TechEd 2012 India |
| 2068 |
Mar 15, 2012 |
SQL SERVER – Install Samples Database Adventure Works for SQL Server 2012 |
| 2067 |
Mar 14, 2012 |
SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video |
| 2066 |
Mar 13, 2012 |
SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India |
| 2065 |
Mar 12, 2012 |
SQL Server – Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave |
| 2064 |
Mar 11, 2012 |
SQL SERVER – 2012 – All Download Links in Single Page – SQL Server 2012 |
| 2063 |
Mar 10, 2012 |
SQLAuthority News – SQL Server 2012 – Microsoft Learning Training and Certification |
| 2062 |
Mar 09, 2012 |
SQLAuthority News – Download Microsoft SQL Server 2012 RTM Now |
| 2061 |
Mar 08, 2012 |
SQL Server – Learning SQL Server Performance: Indexing Basics – Video |
| 2060 |
Mar 07, 2012 |
SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video |
| 2059 |
Mar 06, 2012 |
SQLAuthority News – TechED India 2012 – Bangalore – March 21-23, 2012 |
| 2058 |
Mar 05, 2012 |
SQL SERVER – Top 10 “Ease of Use” Features of expressor Studio |
| 2057 |
Mar 04, 2012 |
SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions – A Must Read |
| 2056 |
Mar 03, 2012 |
SQL SERVER – Various Leap Year Logics |
| 2055 |
Mar 02, 2012 |
SQL Server – SafePeak “Logon Trigger” Feature for Managing Data Access |
| 2054 |
Mar 01, 2012 |
SQLAuthority News – The Best Quotes of “Who Wrote This?” Contest |
| 2053 |
Feb 29, 2012 |
SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video |
| 2052 |
Feb 28, 2012 |
SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function |
| 2051 |
Feb 27, 2012 |
SQL SERVER – Identifying guest User using Policy Based Management |
| 2050 |
Feb 26, 2012 |
SQL SERVER – Standards Support, Protocol, Data Portability – 3 Important SQL Server Documentations for Downloads |
| 2049 |
Feb 25, 2012 |
SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS |
| 2048 |
Feb 24, 2012 |
SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database |
| 2047 |
Feb 23, 2012 |
SQL SERVER – Detecting guest User Permissions – guest User Access Status |
| 2046 |
Feb 22, 2012 |
SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video |
| 2045 |
Feb 21, 2012 |
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in. |
| 2044 |
Feb 20, 2012 |
SQL SERVER – Disable Guest Account – Serious Security Issue |
| 2043 |
Feb 19, 2012 |
SQL SERVER – Migration Assistant for Oracle, MySQL, Sybase and Access v5.2 |
| 2042 |
Feb 18, 2012 |
SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission. |
| 2041 |
Feb 17, 2012 |
SQL SERVER – Solution Part 2 – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser |
| 2040 |
Feb 16, 2012 |
SQL SERVER – Be Different – Be Leader – An Interactive Journey – Questions and Answers – Book and Video |
| 2039 |
Feb 15, 2012 |
SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video |
| 2038 |
Feb 14, 2012 |
SQL SERVER – What is Big Data – An Explanation in Simple Words |
| 2037 |
Feb 13, 2012 |
SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar |
| 2036 |
Feb 12, 2012 |
SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine |
| 2035 |
Feb 11, 2012 |
SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser |
| 2034 |
Feb 10, 2012 |
SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser |
| 2033 |
Feb 09, 2012 |
SQL SERVER – INNER JOIN Returning More Records than Exists in Table |
| 2032 |
Feb 08, 2012 |
SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video |
| 2031 |
Feb 07, 2012 |
SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2 |
| 2030 |
Feb 06, 2012 |
SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner |
| 2029 |
Feb 05, 2012 |
SQLAuthority News – Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery |
| 2028 |
Feb 04, 2012 |
SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors |
| 2027 |
Feb 03, 2012 |
SQLAuthority News – An Incredible Successful SQL Saturday #116 Event – First SQL Saturday in India |
| 2026 |
Feb 02, 2012 |
SQL SERVER – An Inspiring Personal Story – Movie from The Book – Video Course – SQL Server Questions and Answers – Pluralsight |
| 2025 |
Feb 01, 2012 |
SQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31 |
| 2024 |
Jan 31, 2012 |
SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31 |
| 2023 |
Jan 30, 2012 |
SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31 |
| 2022 |
Jan 29, 2012 |
SQL SERVER – Reclaiming Space Back from Database – Quiz – Puzzle – 28 of 31 |
| 2021 |
Jan 28, 2012 |
SQL SERVER – Lots of Date Functions – Find Right One to Use – Quiz – Puzzle – 27 of 31 |
| 2020 |
Jan 27, 2012 |
SQL SERVER – Common Gotcha’s Associated with Common Table Expressions (CTE) – Quiz – Puzzle – 26 of 31 |
| 2019 |
Jan 26, 2012 |
SQLAuthority News – Interview with Book Authors after 2 Months of Book Released |
| 2018 |
Jan 26, 2012 |
SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31 |
| 2017 |
Jan 25, 2012 |
SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31 |
| 2016 |
Jan 24, 2012 |
SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31 |
| 2015 |
Jan 23, 2012 |
SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31 |
| 2014 |
Jan 22, 2012 |
SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31 |
| 2013 |
Jan 21, 2012 |
SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31 |
| 2012 |
Jan 20, 2012 |
SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31 |
| 2011 |
Jan 19, 2012 |
SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31 |
| 2010 |
Jan 18, 2012 |
SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31 |
| 2009 |
Jan 17, 2012 |
SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31 |
| 2008 |
Jan 16, 2012 |
SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31 |
| 2007 |
Jan 16, 2012 |
SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications |
| 2006 |
Jan 15, 2012 |
SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31 |
| 2005 |
Jan 14, 2012 |
SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31 |
| 2004 |
Jan 13, 2012 |
SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31 |
| 2003 |
Jan 12, 2012 |
SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31 |
| 2002 |
Jan 11, 2012 |
SQL SERVER – A Quick Look at expressor Data Quality Solutions |
| 2001 |
Jan 11, 2012 |
SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31 |
| 2000 |
Jan 10, 2012 |
SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31 |
| 1999 |
Jan 09, 2012 |
SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31 |
| 1998 |
Jan 08, 2012 |
SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31 |
| 1997 |
Jan 07, 2012 |
SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31 |
| 1996 |
Jan 06, 2012 |
SQL SERVER – Locking and Blocking – Important Aspect of Database and Effect on Performance – Quiz – Puzzle – 5 of 31 |
| 1995 |
Jan 05, 2012 |
SQL SERVER – An Important Part of Most SELECT statement – WHERE clause – Quiz – Puzzle – 4 of 31 |
| 1994 |
Jan 05, 2012 |
SQLAuthority News – I am Speaking at SQL Saturday 116 – Bangalore, India on January 7, 2012 – First SQL Saturday in India |
| 1993 |
Jan 04, 2012 |
SQL SERVER – Understanding Identity Beyond its Every Increasing Nature – Quiz – Puzzle – 3 of 31 |
| 1992 |
Jan 04, 2012 |
SQLAuthority News – To Err is Human; to Forgive, Divine – Errata of SQL Server Interview Book |
| 1991 |
Jan 03, 2012 |
SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31 |
| 1990 |
Jan 02, 2012 |
SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31 |
| 1989 |
Jan 01, 2012 |
SQL SERVER – Interview Questions and Answers – Perspectives of an Author |
| 1988 |
Dec 31, 2011 |
SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year |
| 1987 |
Dec 30, 2011 |
SQLAuthority News – A Quick History of Writing Three Books in Year 2011 |
| 1986 |
Dec 29, 2011 |
SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow |
| 1985 |
Dec 28, 2011 |
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup |
| 1984 |
Dec 27, 2011 |
SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012 |
| 1983 |
Dec 26, 2011 |
SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped |
| 1982 |
Dec 25, 2011 |
SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users |
| 1981 |
Dec 24, 2011 |
SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column |
| 1980 |
Dec 23, 2011 |
SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore |
| 1979 |
Dec 22, 2011 |
SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience |
| 1978 |
Dec 21, 2011 |
SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT |
| 1977 |
Dec 20, 2011 |
SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function |
| 1976 |
Dec 19, 2011 |
SQLAuthority News – Introduction to expressor Connectivity to Salesforce – expressor Data Integration Applications |
| 1975 |
Dec 18, 2011 |
SQL SERVER – Adventure Works for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0 |
| 1974 |
Dec 17, 2011 |
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.) |
| 1973 |
Dec 16, 2011 |
SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files |
| 1972 |
Dec 15, 2011 |
SQLAuthority News – Online Session Practical Tricks and Tips to Speed up Database Queries Today |
| 1971 |
Dec 14, 2011 |
SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book |
| 1970 |
Dec 13, 2011 |
SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration |
| 1969 |
Dec 12, 2011 |
SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011 |
| 1968 |
Dec 11, 2011 |
SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32 |
| 1967 |
Dec 10, 2011 |
SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 – 4 Saturdays to Go |
| 1966 |
Dec 10, 2011 |
SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid |
| 1965 |
Dec 09, 2011 |
SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object |
| 1964 |
Dec 08, 2011 |
SQL SERVER – Error: Deleting Offline Database and Creating the Same Name |
| 1963 |
Dec 07, 2011 |
SQL SERVER – Plenty of SQL Community Updates |
| 1962 |
Dec 06, 2011 |
SQLAuthority News – SQL Server Interview Questions and Answers Available on Kindle Format as eBook to Download |
| 1961 |
Dec 05, 2011 |
SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 |
| 1960 |
Dec 04, 2011 |
SQLAuthority News – Microsoft SQL Server ODBC Driver for Linux Available Now |
| 1959 |
Dec 03, 2011 |
SQLAuthority News – Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 |
| 1958 |
Dec 02, 2011 |
SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT |
| 1957 |
Dec 01, 2011 |
SQL SERVER – Where Can YOU Get My Books – SQL Server Interview Question and Answers |
| 1956 |
Nov 30, 2011 |
SQL SERVER – Fix: Error: File cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details |
| 1955 |
Nov 29, 2011 |
SQL SERVER – Using expressor Composite Types to Enforce Business Rules |
| 1954 |
Nov 28, 2011 |
SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners |
| 1953 |
Nov 27, 2011 |
SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server |
| 1952 |
Nov 26, 2011 |
SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree |
| 1951 |
Nov 25, 2011 |
SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server 2012 |
| 1950 |
Nov 24, 2011 |
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function |
| 1949 |
Nov 23, 2011 |
SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority |
| 1948 |
Nov 22, 2011 |
SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012 |
| 1947 |
Nov 21, 2011 |
SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example |
| 1946 |
Nov 20, 2011 |
SQL SERVER – Introduction to PERCENTILE_CONT() – Analytic Functions Introduced in SQL Server 2012 |
| 1945 |
Nov 19, 2011 |
SQL SERVER – 2012 RC0 Various Resources and Downloads |
| 1944 |
Nov 18, 2011 |
SQL SERVER – Introduction to PERCENT_RANK() – Analytic Functions Introduced in SQL Server 2012 |
| 1943 |
Nov 17, 2011 |
SQL SERVER – Puzzle to Win Print Book and Free 30 Days Online Training Material |
| 1942 |
Nov 16, 2011 |
SQL SERVER – Puzzle to Win Print Book – Write T-SQL Self Join Without Using LEAD and LAG |
| 1941 |
Nov 15, 2011 |
SQL SERVER – Introduction to LEAD and LAG – Analytic Functions Introduced in SQL Server 2012 |
| 1940 |
Nov 14, 2011 |
SQLAuthority News – A Real Story of Book Getting ‘Out of Stock’ to A 25% Discount Story Available |
| 1939 |
Nov 13, 2011 |
SQL SERVER – CSVExpress and Quick Data Load |
| 1938 |
Nov 12, 2011 |
SQLAuthority News – Various Microsoft SQL Server Documentations Available for Download |
| 1937 |
Nov 11, 2011 |
SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY |
| 1936 |
Nov 10, 2011 |
SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING |
| 1935 |
Nov 09, 2011 |
SQL SERVER – Introduction to FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 |
| 1934 |
Nov 08, 2011 |
SQLAuthority News – Updates on Contests, Books and SQL Server |
| 1933 |
Nov 08, 2011 |
SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012 |
| 1932 |
Nov 07, 2011 |
SQL SERVER – Video – Performance Improvement in Columnstore Index |
| 1931 |
Nov 06, 2011 |
SQL SERVER – Updating Data in A Columnstore Index |
| 1930 |
Nov 05, 2011 |
SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default |
| 1929 |
Nov 04, 2011 |
SQL SERVER 2012 Editions – Highlights of The Cloud-Ready Information Platform |
| 1928 |
Nov 04, 2011 |
SQLAuthority News – SQL Server Interview Questions And Answers Book Summary |
| 1927 |
Nov 03, 2011 |
SQLAuthority News – New Book Released – SQL Server Interview Questions And Answers |
| 1926 |
Nov 02, 2011 |
SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress |
| 1925 |
Nov 01, 2011 |
SQLAuthority News – 5th Anniversary Giveaways |
| 1924 |
Nov 01, 2011 |
SQLAuthority News – History of the Database – 5 Years of Blogging at SQLAuthority |
| 1923 |
Oct 31, 2011 |
SQL SERVER – Database Dynamic Caching by Automatic SQL Server Performance Acceleration |
| 1922 |
Oct 30, 2011 |
SQL SERVER – How to Ignore Columnstore Index Usage in Query |
| 1921 |
Oct 29, 2011 |
SQL SERVER – Fundamentals of Columnstore Index |
| 1920 |
Oct 28, 2011 |
SQLAuthority News – Online Webcast How to Identify Resource Bottlenecks – Wait Types and Queues |
| 1919 |
Oct 27, 2011 |
SQLAuthority News – SQL Server Wait Stats – eBook to Download on Kindle – Answer to FREE PDF Download Request |
| 1918 |
Oct 26, 2011 |
SQLAuthority News – Book Signing Event – SQLPASS 2011 Event Log |
| 1917 |
Oct 25, 2011 |
SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log |
| 1916 |
Oct 24, 2011 |
SQLAuthority News – Story of Seattle – SQLPASS 2011 Event Log |
| 1915 |
Oct 23, 2011 |
SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port. |
| 1914 |
Oct 22, 2011 |
SQLAuthority News – Random Thoughts and Random Ideas |
| 1913 |
Oct 21, 2011 |
SQL SERVER – DATEDIFF – Accuracy of Various Dateparts |
| 1912 |
Oct 20, 2011 |
SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution |
| 1911 |
Oct 19, 2011 |
SQL SERVER – A Simple Quiz – T-SQL Brain Trick |
| 1910 |
Oct 18, 2011 |
SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012 |
| 1909 |
Oct 18, 2011 |
SQLAuthority News – Your Performance Story – My Contribution to Your Learning |
| 1908 |
Oct 17, 2011 |
SQLAuthority News – SafePeak Releases a Major Update: SafePeak version 2.1 for SQL Server Performance Acceleration |
| 1907 |
Oct 16, 2011 |
SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry |
| 1906 |
Oct 15, 2011 |
SQLAuthority News – SQL Server 2008 SP3 Available to Download |
| 1905 |
Oct 14, 2011 |
SQL SERVER – SQLPASS Memory Lane of 2009 and 2010 |
| 1904 |
Oct 13, 2011 |
SQLAuthority News – SQLPASS – Today FREE 100 SQL Wait Stats Book Print Copy – Book Signing |
| 1903 |
Oct 12, 2011 |
SQLAuthority News – SQLPASS – 100 SQL Wait Stats Book Print Copy Giveaway – A Book Every Minute for an Hour Tomorrow |
| 1902 |
Oct 11, 2011 |
SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool |
| 1901 |
Oct 11, 2011 |
SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle |
| 1900 |
Oct 10, 2011 |
SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You! |
| 1899 |
Oct 09, 2011 |
SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance |
| 1898 |
Oct 08, 2011 |
SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions |
| 1897 |
Oct 07, 2011 |
SQL SERVER – Server Side Paging in SQL Server CE (Compact Edition) |
| 1896 |
Oct 06, 2011 |
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations() |
| 1895 |
Oct 05, 2011 |
SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special |
| 1894 |
Oct 04, 2011 |
SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers |
| 1893 |
Oct 04, 2011 |
SQL SERVER – CE – 3 Links to Performance Tuning Compact Edition |
| 1892 |
Oct 03, 2011 |
SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool |
| 1891 |
Oct 02, 2011 |
SQL SERVER – CE – List of Information_Schema System Tables |
| 1890 |
Oct 01, 2011 |
SQL SERVER – CE – Samples Database for SQL CE 4.0 |
| 1889 |
Sep 30, 2011 |
SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System |
| 1888 |
Sep 30, 2011 |
SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume |
| 1887 |
Sep 29, 2011 |
SQLAuthority News – Various Ways to Stay in Touch with SQLAuthority.com – Best Practices |
| 1886 |
Sep 28, 2011 |
SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns |
| 1885 |
Sep 28, 2011 |
SQLAuthority News – Tomorrow Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index |
| 1884 |
Sep 27, 2011 |
SQLAuthority News – 31 Millions Views – Free 5 Print Copy of SQL Wait Types and Queues |
| 1883 |
Sep 26, 2011 |
SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index |
| 1882 |
Sep 26, 2011 |
SQL SERVER – Denali – Startup Parameters Easy to Configure |
| 1881 |
Sep 25, 2011 |
SQLAuthority News – Learn SQL Azure at Microsoft Virtual Academy |
| 1880 |
Sep 24, 2011 |
SQL SERVER – Denali – Download CTP3 Demo VHD Including Fully Configured Services and Integration with SharePoint 2010 and Office 2010 |
| 1879 |
Sep 23, 2011 |
SQL SERVER – Puzzle – Usage of New Index Hints for Denali – ForceSeek and ForceScan |
| 1878 |
Sep 22, 2011 |
SQL SERVER – Learning SSAS (SQL Server Analysis Services) Online in 6 Hours – Top Down Designing and Bottom Up Designing |
| 1877 |
Sep 22, 2011 |
SQLAuthority News – Latest expressor Data Integration Platform Posts |
| 1876 |
Sep 21, 2011 |
SQL SERVER – Denali – 14 New Functions – A Quick Guide |
| 1875 |
Sep 20, 2011 |
SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction |
| 1874 |
Sep 19, 2011 |
SQL SERVER – Denali – Date and Time Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS() – TIMEFROMPARTS() – SMALLDATETIMEFROMPARTS() – DATETIMEOFFSETFROMPARTS() – A Quick Introduction |
| 1873 |
Sep 18, 2011 |
SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach |
| 1872 |
Sep 18, 2011 |
SQLAuthority News – Automation of Data Mining Using Integration Services |
| 1871 |
Sep 17, 2011 |
SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction |
| 1870 |
Sep 16, 2011 |
SQL SERVER – Denali – String Function – CONCAT() – A Quick Introduction |
| 1869 |
Sep 15, 2011 |
SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring |
| 1868 |
Sep 14, 2011 |
SQL SERVER – Introduction to expressor 3.4 Lookup Tables |
| 1867 |
Sep 13, 2011 |
SQL SERVER – Denali – New Functions and Shorthand for CASE Statement |
| 1866 |
Sep 12, 2011 |
SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds |
| 1865 |
Sep 12, 2011 |
SQL SERVER – DBA Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions |
| 1864 |
Sep 11, 2011 |
SQL SERVER – Denali – Logical Function – CHOOSE() – A Quick Introduction |
| 1863 |
Sep 10, 2011 |
SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction |
| 1862 |
Sep 09, 2011 |
SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT() |
| 1861 |
Sep 08, 2011 |
SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction |
| 1860 |
Sep 07, 2011 |
SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction |
| 1859 |
Sep 07, 2011 |
SQL SERVER – A Guide to Integrating SQL Server with XML, C#, and PowerShell – Book Available for SQL Server Certification |
| 1858 |
Sep 06, 2011 |
SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction |
| 1857 |
Sep 06, 2011 |
SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide |
| 1856 |
Sep 05, 2011 |
SQLAuthority News – Whitepaper – Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations – Consolidating Databases Using Virtualization Planning Guide |
| 1855 |
Sep 05, 2011 |
SQL SERVER – Programming and Development – Book Available for SQL Server Certification |
| 1854 |
Sep 04, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – OpenXML Options – Day 35 of 35 |
| 1853 |
Sep 03, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35 |
| 1852 |
Sep 02, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35 |
| 1851 |
Sep 02, 2011 |
SQLAuthority News – Programming & Development For Microsoft SQL Server 2008 |
| 1850 |
Sep 01, 2011 |
SQLAuthority News – Shaivi’s Birthday – SQL Wait Stats Joes 2 Pros Book Released Today – 30 Million Views Completed |
| 1849 |
Sep 01, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35 |
| 1848 |
Aug 31, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 31 of 35 |
| 1847 |
Aug 30, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 30 of 35 |
| 1846 |
Aug 29, 2011 |
SQL SERVER – SSQL Architecture Basics – Core Architecture Concepts – Book Available for SQL Server Certification |
| 1845 |
Aug 29, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 29 of 35 |
| 1844 |
Aug 28, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Structured Error Handling – Day 28 of 35 |
| 1843 |
Aug 27, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – SQL Server Error Messages – Day 27 of 35 |
| 1842 |
Aug 26, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Functions – Day 26 of 35 |
| 1841 |
Aug 25, 2011 |
SQL SERVER – Author’s Book is Available in India and USA |
| 1840 |
Aug 25, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Store Procedure Parameters – Day 25 of 35 |
| 1839 |
Aug 24, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35 |
| 1838 |
Aug 23, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Views – Day 23 of 35 |
| 1837 |
Aug 22, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Constraints – Day 22 of 35 |
| 1836 |
Aug 22, 2011 |
SQL SERVER – SQL Query Techniques For Microsoft SQL Server 2008 – Book Available for SQL Server Certification |
| 1835 |
Aug 21, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Statistics – Day 21 of 35 |
| 1834 |
Aug 20, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Page Split – Day 20 of 35 |
| 1833 |
Aug 19, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding – Day 19 of 35 |
| 1832 |
Aug 18, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35 |
| 1831 |
Aug 17, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Sparse Data and Space Used by Sparse Data – Day 17 of 35 |
| 1830 |
Aug 16, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35 |
| 1829 |
Aug 16, 2011 |
SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants |
| 1828 |
Aug 15, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35 |
| 1827 |
Aug 14, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Output Clause in Simple Examples – Day 14 of 35 |
| 1826 |
Aug 13, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – Advanced NTILE in Detail – Day 13 of 35 |
| 1825 |
Aug 12, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35 |
| 1824 |
Aug 11, 2011 |
SQL SERVER – SafePeak – The Plug and Play Immediate Acceleration Solution |
| 1823 |
Aug 11, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Advanced Aggregates with the Over Clause – Day 11 of 35 |
| 1822 |
Aug 10, 2011 |
SQL SERVER – Who needs ETL Version Control? |
| 1821 |
Aug 10, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Aggregates with the Over Clause – Day 10 of 35 |
| 1820 |
Aug 10, 2011 |
SQL SERVER – Use INSERT INTO … SELECT instead of Cursor |
| 1819 |
Aug 09, 2011 |
SQL SERVER – The SQL Hands-On Guide for Beginners – Book Available for SQL Server Certification |
| 1818 |
Aug 09, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35 |
| 1817 |
Aug 08, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35 |
| 1816 |
Aug 07, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Dirty Records and Table Hints – Day 7 of 35 |
| 1815 |
Aug 06, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Row Constructors – Day 6 of 35 |
| 1814 |
Aug 05, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35 |
| 1813 |
Aug 04, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35 |
| 1812 |
Aug 03, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35 |
| 1811 |
Aug 02, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard – Querying Special Characters – Day 2 of 35 |
| 1810 |
Aug 01, 2011 |
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard Basics Recap – Day 1 of 35 |
| 1809 |
Aug 01, 2011 |
SQL SERVER – Win a Book a Day – Contest Rules – Day 0 of 35 |
| 1808 |
Jul 31, 2011 |
SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31 |
| 1807 |
Jul 30, 2011 |
SQL SERVER – Interview Questions and Answers – Guest Post by Jacob Sebastian – Day 30 of 31 |
| 1806 |
Jul 29, 2011 |
SQL SERVER – Interview Questions and Answers – Guest Post by Feodor Georgiev – Day 29 of 31 |
| 1805 |
Jul 28, 2011 |
SQL SERVER – Interview Questions and Answers – Guest Post by Nakul Vachhrajani – Day 28 of 31 |
| 1804 |
Jul 28, 2011 |
SQL SERVER – Latest expressor Data Integration Platform Posts |
| 1803 |
Jul 27, 2011 |
SQL SERVER – Interview Questions and Answers – Guest Post by Rick Morelan – Day 27 of 31 |
| 1802 |
Jul 26, 2011 |
SQL SERVER – Interview Questions and Answers – Guest Post by Malathi Mahadevan – Day 26 of 31 |
| 1801 |
Jul 25, 2011 |
SQL SERVER – Azure Interview Questions and Answers – Guest Post by Paras Doshi – Day 25 of 31 |
| 1800 |
Jul 24, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 24 of 31 |
| 1799 |
Jul 23, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 23 of 31 |
| 1798 |
Jul 22, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 22 of 31 |
| 1797 |
Jul 21, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 21 of 31 |
| 1796 |
Jul 20, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 20 of 31 |
| 1795 |
Jul 19, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 19 of 31 |
| 1794 |
Jul 18, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 18 of 31 |
| 1793 |
Jul 17, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 17 of 31 |
| 1792 |
Jul 16, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31 |
| 1791 |
Jul 15, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 15 of 31 |
| 1790 |
Jul 14, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 14 of 31 |
| 1789 |
Jul 13, 2011 |
SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes |
| 1788 |
Jul 13, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 13 of 31 |
| 1787 |
Jul 12, 2011 |
SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters |
| 1786 |
Jul 12, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 12 of 31 |
| 1785 |
Jul 11, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 11 of 31 |
| 1784 |
Jul 10, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 10 of 31 |
| 1783 |
Jul 09, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 9 of 31 |
| 1782 |
Jul 08, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 8 of 31 |
| 1781 |
Jul 08, 2011 |
SQL SERVER – Introduction to expressor Datascript Modules |
| 1780 |
Jul 07, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 7 of 31 |
| 1779 |
Jul 06, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 6 of 31 |
| 1778 |
Jul 05, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 5 of 31 |
| 1777 |
Jul 04, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 4 of 31 |
| 1776 |
Jul 03, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 3 of 31 |
| 1775 |
Jul 02, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 2 of 31 |
| 1774 |
Jul 01, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Introduction – Day 1 of 31 |
| 1773 |
Jul 01, 2011 |
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31 |
| 1772 |
Jun 30, 2011 |
SQL SERVER – Two Puzzles – Answer and Win USD 25 Gift Card |
| 1771 |
Jun 29, 2011 |
SQL SERVER – Find Details for Statistics of Whole Database – DMV – T-SQL Script |
| 1770 |
Jun 28, 2011 |
SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com |
| 1769 |
Jun 27, 2011 |
SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator |
| 1768 |
Jun 26, 2011 |
SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers |
| 1767 |
Jun 25, 2011 |
SQLAuthority News – Download Whitepaper – SQL Server 2008 R2 Analysis Services Operations Guide |
| 1766 |
Jun 24, 2011 |
SQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints |
| 1765 |
Jun 23, 2011 |
SQLAuthority News – Ahmedabad Tech Ed On Road June 11, 2011 – An Event to Remember – A Grand Success of Community Tech Days |
| 1764 |
Jun 22, 2011 |
SQL SERVER – SSAS – Multidimensional Space Terms and Explanation |
| 1763 |
Jun 22, 2011 |
SQL SERVER – List of Article on Expressor Data Integration Platform |
| 1762 |
Jun 21, 2011 |
SQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL |
| 1761 |
Jun 20, 2011 |
SQLAuthority News – Job Interviewing the Right Way (and for the Right Reasons) – Guest Post by Feodor Georgiev |
| 1760 |
Jun 19, 2011 |
SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot |
| 1759 |
Jun 18, 2011 |
SQL SERVER – Selecting Domain from Email Address |
| 1758 |
Jun 17, 2011 |
SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once |
| 1757 |
Jun 16, 2011 |
SQL SERVER – Free Online Training on .net and SQL |
| 1756 |
Jun 15, 2011 |
SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT(*) |
| 1755 |
Jun 14, 2011 |
SQLAuthority News – BI Quiz Question – How to Optimize Cube? – Hints |
| 1754 |
Jun 14, 2011 |
SQL SERVER – Watch Online and Download – Inside of Next Generation SQL Server – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer |
| 1753 |
Jun 14, 2011 |
SQL SERVER – First Month as DBA Trainee – Disasters and Recovery |
| 1752 |
Jun 13, 2011 |
SQL SERVER – Extending SQL Azure with Azure worker role – Guest Post by Paras Doshi |
| 1751 |
Jun 12, 2011 |
SQL SERVER – PHP on Windows and SQL Server Training Kit |
| 1750 |
Jun 11, 2011 |
SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor |
| 1749 |
Jun 10, 2011 |
SQLAuthority News – Presenting at Tech-Ed On Road – Ahmedabad – June 11, 2011 – Wait Types and Queues |
| 1748 |
Jun 09, 2011 |
SQL SERVER – Online Session on What is New in Denali – Today Online |
| 1747 |
Jun 08, 2011 |
SQL SERVER – 5 Tips for Improving Your Data with expressor Studio |
| 1746 |
Jun 07, 2011 |
SQL SERVER – Three Puzzling Questions – Need Your Answer |
| 1745 |
Jun 06, 2011 |
SQL SERVER – BI Quiz – Troubleshooting Cube Performance |
| 1744 |
Jun 05, 2011 |
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit – Download – May Update |
| 1743 |
Jun 05, 2011 |
SQLAuthority News – Download Pre-configured VHD – SQL Server 2008 R2 Standard on Windows Server 2008 R2 SP1 Standard |
| 1742 |
Jun 04, 2011 |
SQL SERVER – Question to You – When to use Function and When to use Stored Procedure |
| 1741 |
Jun 03, 2011 |
SQLAuthority News – Community Tech Days – TechEd on The Road – Ahmedabad – June 11, 2011 |
| 1740 |
Jun 02, 2011 |
SQL SERVER – Puzzle – Statistics are not Updated but are Created Once |
| 1739 |
Jun 01, 2011 |
SQL SERVER – Creating All New Database with Full Recovery Model |
| 1738 |
May 31, 2011 |
SQLAuthority News – Best SQLAuthority Posts of May |
| 1737 |
May 30, 2011 |
SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*) |
| 1736 |
May 29, 2011 |
SQL Azure – SQL Azure Throttling and Decoding Reason Codes |
| 1735 |
May 28, 2011 |
SQL SERVER – A Quick Notes on SQL Azure |
| 1734 |
May 27, 2011 |
SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server |
| 1733 |
May 26, 2011 |
SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON |
| 1732 |
May 25, 2011 |
SQLAuthority News – Most Valuable Photographer – Vijay Raj |
| 1731 |
May 24, 2011 |
SQL SERVER – Beginning SQL Azure – Article Links by Dhananjay Kumar |
| 1730 |
May 23, 2011 |
SQL SERVER – Running SSIS Package in Scheduled Job |
| 1729 |
May 22, 2011 |
SQL SERVER – Download PowerPivot Security Architecture Diagram |
| 1728 |
May 21, 2011 |
SQL SERVER – Running SSIS Package From Command Line |
| 1727 |
May 20, 2011 |
SQL SERVER – Management Studio and Browser in Same Application |
| 1726 |
May 19, 2011 |
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD |
| 1725 |
May 18, 2011 |
SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer) |
| 1724 |
May 17, 2011 |
SQLAuthority News – Facebook Page and Twitter – Connect Using Social Media |
| 1723 |
May 16, 2011 |
SQL SERVER – SQL Server Compression Estimator – Codeplex |
| 1722 |
May 15, 2011 |
SQL SERVER – Attending MVP Open Day – May 2011 |
| 1721 |
May 14, 2011 |
SQLAuthority News – Restart Remote Computer – Shutdown Remote Computer |
| 1720 |
May 13, 2011 |
SQL SERVER – Vote for My Session in SQL PASS |
| 1719 |
May 12, 2011 |
SQL SERVER – Import CSV File into Database Table Using SSIS |
| 1718 |
May 11, 2011 |
SQL SERVER – expressor 3.2 Release Review |
| 1717 |
May 10, 2011 |
SQL SERVER – Resource Database ID – 32767 |
| 1716 |
May 10, 2011 |
SQL SERVER – Common Table Expression (CTE) and Few Observation |
| 1715 |
May 09, 2011 |
SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007 |
| 1714 |
May 08, 2011 |
SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object? |
| 1713 |
May 07, 2011 |
SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects |
| 1712 |
May 06, 2011 |
SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer |
| 1711 |
May 05, 2011 |
SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer |
| 1710 |
May 04, 2011 |
SQL SERVER – Cartoon Challenge – 140 Character Winner is Here |
| 1709 |
May 04, 2011 |
SQL SERVER – Interview on Wait Types and Wait Queues |
| 1708 |
May 03, 2011 |
SQL SERVER – Error: Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc – ‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195) |
| 1707 |
May 02, 2011 |
SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in Denali |
| 1706 |
May 01, 2011 |
SQL SERVER – Migration Assistant for Access, MySQL, Oracle, Sybase |
| 1705 |
Apr 30, 2011 |
SQL SERVER – CTAS – Create Table As SELECT – What is CTAS? |
| 1704 |
Apr 29, 2011 |
SQL SERVER – Denali – Executing Stored Procedure with Result Sets |
| 1703 |
Apr 28, 2011 |
SQL SERVER – Denali – Executing Stored Procedure with Result Sets |
| 1702 |
Apr 27, 2011 |
SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database |
| 1701 |
Apr 26, 2011 |
SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course |
| 1700 |
Apr 25, 2011 |
SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone |
| 1699 |
Apr 24, 2011 |
SQL SERVER – How to ALTER CONSTRAINT |
| 1698 |
Apr 23, 2011 |
SQL SERVER – Using Decode in SQL Server |
| 1697 |
Apr 22, 2011 |
SQL SERVER – Potential Bottlenecks for Performance |
| 1696 |
Apr 21, 2011 |
SQL SERVER – Prevent Constraint to Allow NULL |
| 1695 |
Apr 20, 2011 |
SQLAuthority News – Last 5 Days to WIN Windows Phone 7 – 140 Words to Win |
| 1694 |
Apr 19, 2011 |
SQLAuthority News – Sudden Death of SSD on my Laptop – A Warning for SSD Users |
| 1693 |
Apr 18, 2011 |
SQL SERVER – Speaking on T-SQL Worst Practices at Great Indian Developer Summit 2011 – Bangalore |
| 1692 |
Apr 17, 2011 |
SQL SERVER – Applying NOLOCK Hint at Query Level – NOLOCK for whole Transaction |
| 1691 |
Apr 16, 2011 |
SQL SERVER – Making Database to Read Only – Changing Database to Read/Write |
| 1690 |
Apr 15, 2011 |
SQL SERVER – Finding Location of Log File when Primary Datafile is Crashed |
| 1689 |
Apr 14, 2011 |
SQL SERVER – Transaction Log Impact Detection Using DMV – dm_tran_database_transactions |
| 1688 |
Apr 13, 2011 |
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.) |
| 1687 |
Apr 12, 2011 |
SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL |
| 1686 |
Apr 11, 2011 |
SQL SERVER – expressor Studio Includes Powerful Scripting Capabilities |
| 1685 |
Apr 10, 2011 |
SQL SERVER – TempDB in RAM for Performance |
| 1684 |
Apr 09, 2011 |
SQL SERVER – Add New Column With Default Value |
| 1683 |
Apr 08, 2011 |
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day Next |
| 1682 |
Apr 07, 2011 |
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 3 |
| 1681 |
Apr 06, 2011 |
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 2 |
| 1680 |
Apr 05, 2011 |
SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL |
| 1679 |
Apr 04, 2011 |
SQL SERVER – MondayMeme – 11 Words or Less |
| 1678 |
Apr 04, 2011 |
SQLAuthority News – A Million Hits a Month – A Milestone |
| 1677 |
Apr 03, 2011 |
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 1 |
| 1676 |
Apr 02, 2011 |
SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 0 |
| 1675 |
Apr 01, 2011 |
SQLAuthority News – Today is First April – April Fool’s Day |
| 1674 |
Mar 31, 2011 |
SQL SERVER – ‘Denali’ – A Simple Example of Contained Databases |
| 1673 |
Mar 30, 2011 |
SQL SERVER – TechEd 2011 – Random Question and Answers |
| 1672 |
Mar 29, 2011 |
SQL SERVER – Fix : Error : The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details |
| 1671 |
Mar 28, 2011 |
SQL SERVER – Denali – Improvement in Startup Options |
| 1670 |
Mar 27, 2011 |
SQL SERVER – 32 Bit – 64 Bit – HTML5 – Database Backup Restore |
| 1669 |
Mar 26, 2011 |
SQL SERVER – Related Scripts for TechEd 2011 Presentations |
| 1668 |
Mar 25, 2011 |
SQLAuthority News – Win Surprise Gift at TechED 2011 Sessions – Wait Types and Extended Events |
| 1667 |
Mar 24, 2011 |
SQL SERVER – Tomorrow 2 Sessions on Performance Tuning at TechEd India 2011 – March 25, 2011 |
| 1666 |
Mar 23, 2011 |
SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID |
| 1665 |
Mar 22, 2011 |
SQLAuthority News – Solid Quality Journal – Importance of Statistics |
| 1664 |
Mar 21, 2011 |
SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download |
| 1663 |
Mar 20, 2011 |
SQL SERVER – Denali Feature – Zoom Query Editor |
| 1662 |
Mar 19, 2011 |
SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big |
| 1661 |
Mar 18, 2011 |
SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement |
| 1660 |
Mar 17, 2011 |
SQL SERVER – Tell me What You Want to Listen – My 2 TechED 2011 Sessions |
| 1659 |
Mar 16, 2011 |
SQLAuthority News – I am Presenting 2 Sessions at TechEd India |
| 1658 |
Mar 15, 2011 |
SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer |
| 1657 |
Mar 14, 2011 |
SQL SERVER – Guest Post – Architecting Data Warehouse – Niraj Bhatt |
| 1656 |
Mar 13, 2011 |
SQL SERVER – Pending IO request in SQL Server – DMV |
| 1655 |
Mar 12, 2011 |
SQLAuthority News – Download – Microsoft SQL Server Compact 4.0 |
| 1654 |
Mar 11, 2011 |
SQL SERVER – Finding Latch Statistics |
| 1653 |
Mar 10, 2011 |
SQL SERVER – Sharing your ETL Resources Across Applications with Ease |
| 1652 |
Mar 09, 2011 |
SQLAuthority News – Stay Connected and Social Media |
| 1651 |
Mar 08, 2011 |
SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL) |
| 1650 |
Mar 07, 2011 |
SQL SERVER – Enable PowerPivot Plugin in Excel |
| 1649 |
Mar 06, 2011 |
SQL SERVER – Running Multiple Batch Files Together in Parallel |
| 1648 |
Mar 05, 2011 |
SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide |
| 1647 |
Mar 04, 2011 |
SQL SERVER – Concurrancy Problems and their Relationship with Isolation Level |
| 1646 |
Mar 03, 2011 |
SQL SERVER – Demo Script – Keeping CPU Busy |
| 1645 |
Mar 02, 2011 |
SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave |
| 1644 |
Mar 01, 2011 |
SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart |
| 1643 |
Feb 28, 2011 |
SQL SERVER – Summary of Month – Wait Type – Day 28 of 28 |
| 1642 |
Feb 27, 2011 |
SQL SERVER – Best Reference – Wait Type – Day 27 of 28 |
| 1641 |
Feb 26, 2011 |
SQL SERVER – Guest Post – Glenn Berry – Wait Type – Day 26 of 28 |
| 1640 |
Feb 25, 2011 |
SQL SERVER – 2011 – Wait Type – Day 25 of 28 |
| 1639 |
Feb 24, 2011 |
SQL SERVER – 2000 – DBCC SQLPERF(waitstats) – Wait Type – Day 24 of 28 |
| 1638 |
Feb 23, 2011 |
SQL SERVER – OLEDB – Link Server – Wait Type – Day 23 of 28 |
| 1637 |
Feb 22, 2011 |
SQL SERVER – Guest Post – Jacob Sebastian – Filestream – Wait Types – Wait Queues – Day 22 of 28 |
| 1636 |
Feb 21, 2011 |
SQL SERVER – Guest Posts – Feodor Georgiev – The Context of Our Database Environment – Going Beyond the Internal SQL Server Waits – Wait Type – Day 21 of 28 |
| 1635 |
Feb 20, 2011 |
SQL SERVER – MSQL_XP – Wait Type – Day 20 of 28 |
| 1634 |
Feb 19, 2011 |
SQL SERVER – PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 19 of 28 |
| 1633 |
Feb 18, 2011 |
SQL SERVER – LOGBUFFER – Wait Type – Day 18 of 28 |
| 1632 |
Feb 17, 2011 |
SQL SERVER – Introduction to Adaptive ETL Tool – How adaptive is your ETL? |
| 1631 |
Feb 17, 2011 |
SQL SERVER – WRITELOG – Wait Type – Day 17 of 28 |
| 1630 |
Feb 16, 2011 |
SQL SERVER – Guest Post – Jonathan Kehayias – Wait Type – Day 16 of 28 |
| 1629 |
Feb 15, 2011 |
SQL SERVER – LCK_M_XXX – Wait Type – Day 15 of 28 |
| 1628 |
Feb 14, 2011 |
SQL SERVER – BACKUPIO, BACKUPBUFFER – Wait Type – Day 14 of 28 |
| 1627 |
Feb 13, 2011 |
SQL SERVER – FT_IFTS_SCHEDULER_IDLE_WAIT – Full Text – Wait Type – Day 13 of 28 |
| 1626 |
Feb 12, 2011 |
SQL SERVER – PAGELATCH_DT, PAGELATCH_EX, PAGELATCH_KP, PAGELATCH_SH, PAGELATCH_UP – Wait Type – Day 12 of 28 |
| 1625 |
Feb 11, 2011 |
SQL SERVER – ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28 |
| 1624 |
Feb 10, 2011 |
SQL SERVER – IO_COMPLETION – Wait Type – Day 10 of 28 |
| 1623 |
Feb 10, 2011 |
SQLAuthority News – DotNET Challenge of Sorting Generic List |
| 1622 |
Feb 09, 2011 |
SQL SERVER – PAGEIOLATCH_DT, PAGEIOLATCH_EX, PAGEIOLATCH_KP, PAGEIOLATCH_SH, PAGEIOLATCH_UP – Wait Type – Day 9 of 28 |
| 1621 |
Feb 08, 2011 |
SQL SERVER – SOS_SCHEDULER_YIELD – Wait Type – Day 8 of 28 |
| 1620 |
Feb 08, 2011 |
SQL SERVER – Automation Process Good or Ugly |
| 1619 |
Feb 07, 2011 |
SQL SERVER – CXPACKET – Parallelism – Advanced Solution – Wait Type – Day 7 of 28 |
| 1618 |
Feb 07, 2011 |
SQLAuthority News – Presenting at Virtual Tech Days TechEd Pre-Con – February 9, 2011 |
| 1617 |
Feb 06, 2011 |
SQL SERVER – CXPACKET – Parallelism – Usual Solution – Wait Type – Day 6 of 28 |
| 1616 |
Feb 05, 2011 |
SQL SERVER – Capturing Wait Types and Wait Stats Information at Interval – Wait Type – Day 5 of 28 |
| 1615 |
Feb 04, 2011 |
SQL SERVER – DMV – sys.dm_os_waiting_tasks and sys.dm_exec_requests – Wait Type – Day 4 of 28 |
| 1614 |
Feb 03, 2011 |
SQL SERVER – DMV – sys.dm_os_wait_stats Explanation – Wait Type – Day 3 of 28 |
| 1613 |
Feb 02, 2011 |
SQL SERVER – Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28 |
| 1612 |
Feb 01, 2011 |
SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28 |
| 1611 |
Feb 01, 2011 |
SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28 |
| 1610 |
Jan 31, 2011 |
SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor |
| 1609 |
Jan 30, 2011 |
SQL SERVER – Denali – SEQUENCE is not IDENTITY |
| 1608 |
Jan 29, 2011 |
SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE |
| 1607 |
Jan 28, 2011 |
SQLAuthority News – Deployment guide for Microsoft SharePoint Foundation 2010 |
| 1606 |
Jan 27, 2011 |
SQL SERVER – What is a Technology Evangelist? |
| 1605 |
Jan 26, 2011 |
SQL SERVER – Reducing Page Contention on TempDB |
| 1604 |
Jan 25, 2011 |
SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V |
| 1603 |
Jan 24, 2011 |
SQL SERVER – Denali – Multi-Monitor SSMS Windows |
| 1602 |
Jan 23, 2011 |
SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback |
| 1601 |
Jan 22, 2011 |
SQL SERVER- Differences Between Left Join and Left Outer Join |
| 1600 |
Jan 21, 2011 |
SQLAuthority News – 1600 Blog Post Articles – A Milestone |
| 1599 |
Jan 20, 2011 |
SQLAuthority News – Scaling Up Your Data Warehouse with SQL Server 2008 R2 |
| 1598 |
Jan 19, 2011 |
SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance |
| 1597 |
Jan 18, 2011 |
SQL SERVER – 4 Tips for ETL Software IDE Developers |
| 1596 |
Jan 17, 2011 |
SQL SERVER – A Funny Cartoon on Index |
| 1595 |
Jan 16, 2011 |
SQLAuthority News – Whitepaper Download – Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries |
| 1594 |
Jan 15, 2011 |
SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2 |
| 1593 |
Jan 14, 2011 |
SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications |
| 1592 |
Jan 13, 2011 |
SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name |
| 1591 |
Jan 12, 2011 |
SQLAuthority News – Download SQL Server 2008 R2 Upgrade Technical Reference Guide |
| 1590 |
Jan 11, 2011 |
SQL SERVER – Performance Tuning Resolution |
| 1589 |
Jan 10, 2011 |
SQLAuthority News – Free Trip on SQL Cruise |
| 1588 |
Jan 09, 2011 |
SQL SERVER – master Database Log File Grew Too Big |
| 1587 |
Jan 08, 2011 |
SQL SERVER – Get File Statistics Using fn_virtualfilestats |
| 1586 |
Jan 07, 2011 |
SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer |
| 1585 |
Jan 06, 2011 |
SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine |
| 1584 |
Jan 05, 2011 |
SQL SERVER – Copy Statistics from One Server to Another Server |
| 1583 |
Jan 04, 2011 |
SQL SERVER – 2008 – Unused Index Script – Download |
| 1582 |
Jan 03, 2011 |
SQL SERVER – 2008 – Missing Index Script – Download |
| 1581 |
Jan 02, 2011 |
SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file |
| 1580 |
Jan 01, 2011 |
SQLAuthority News – Resolution for New Year 2011 |
| 1579 |
Dec 31, 2010 |
SQLAuthority News – Community Service and Public Speaking Engagements |
| 1578 |
Dec 30, 2010 |
SQL SERVER – Detect Virtual Log Files (VLF) in LDF |
| 1577 |
Dec 29, 2010 |
SQLAuthority News – My Evaluation of Singapore SharePoint Conference |
| 1576 |
Dec 28, 2010 |
SQL SERVER – Plan Cache and Data Cache in Memory |
| 1575 |
Dec 27, 2010 |
SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber |
| 1574 |
Dec 26, 2010 |
SQL SERVER – Server Side Paging in SQL Server Denali – Part2 |
| 1573 |
Dec 25, 2010 |
SQLAuthority News – 18 Seconds of Fame – My PASS Experience |
| 1572 |
Dec 24, 2010 |
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4 |
| 1571 |
Dec 23, 2010 |
SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2 |
| 1570 |
Dec 22, 2010 |
SQL SERVER – Public Training and Private Training – Differences and Similarities – Public Training vs Private Training |
| 1569 |
Dec 21, 2010 |
SQL SERVER – Index Created on View not Used Often – Observation of the View |
| 1568 |
Dec 20, 2010 |
SQL SERVER – Securing TRUNCATE Permissions in SQL Server |
| 1567 |
Dec 19, 2010 |
SQLAuthority News – Microsoft SQL Server 2005 Service Pack 4 RTM |
| 1566 |
Dec 19, 2010 |
SQL SERVER – SQL Server 2008 with Service Pack 2 |
| 1565 |
Dec 18, 2010 |
SQL SERVER – Index Created on View not Used Often – Limitation of the View 12 |
| 1564 |
Dec 17, 2010 |
SQLAuthority News – A Successful Community TechDays at Ahmedabad – December 11, 2010 |
| 1563 |
Dec 16, 2010 |
SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison |
| 1562 |
Dec 15, 2010 |
SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative |
| 1561 |
Dec 14, 2010 |
SQL SERVER – What the Business Says Is Not What the Business Wants |
| 1560 |
Dec 13, 2010 |
SQL SERVER – What is Page Life Expectancy (PLE) Counter |
| 1559 |
Dec 12, 2010 |
SQL SERVER – Activity Monitor and Performance Issue |
| 1558 |
Dec 11, 2010 |
SQLAuthority News – SQL Server 2008 R2 System Views Map |
| 1557 |
Dec 10, 2010 |
SQL SEVER – Finding Memory Pressure – External and Internal |
| 1556 |
Dec 09, 2010 |
SQLAuthority News – Community Tech Days – December 11, 2010 |
| 1555 |
Dec 08, 2010 |
SQL SERVER – Installing AdventureWorks for SQL Server Denali |
| 1554 |
Dec 07, 2010 |
SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010 |
| 1553 |
Dec 06, 2010 |
SQL SERVER – Solution – Challenge – Puzzle – Usage of FAST Hint |
| 1552 |
Dec 05, 2010 |
SQL SERVER – Solution – Puzzle – Challenge – Error While Converting Money to Decimal |
| 1551 |
Dec 04, 2010 |
SQLAuthority News – Statistics Used by the Query Optimizer in Microsoft SQL Server 2008 – Microsoft Whitepaper |
| 1550 |
Dec 03, 2010 |
SQL SERVER – A Successful Performance Tuning Seminar – Hyderabad – Nov 27-28, 2010 – Next Pune |
| 1549 |
Dec 02, 2010 |
SQLAuthority News – Community Tech Days – A SQL Legends in Ahmedabad – December 11, 2010 |
| 1548 |
Dec 01, 2010 |
SQL SERVER – 3 Simple Puzzles – Need Your Suggestions |
| 1547 |
Nov 30, 2010 |
SQL SERVER – Automated Type Conversion using Expressor Studio |
| 1546 |
Nov 29, 2010 |
SQL SERVER – DBA or DBD? – Database Administrator or Database Developer |
| 1545 |
Nov 28, 2010 |
SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists |
| 1544 |
Nov 27, 2010 |
SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal |
| 1543 |
Nov 26, 2010 |
SQL SERVER – Challenge – Puzzle – Usage of FAST Hint |
| 1542 |
Nov 25, 2010 |
SQL SERVER – Concat Function in SQL Server – SQL Concatenation |
| 1541 |
Nov 24, 2010 |
SQLAuthority News – What’s New in SQL Server “Denali” |
| 1540 |
Nov 23, 2010 |
SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience |
| 1539 |
Nov 22, 2010 |
SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010 |
| 1538 |
Nov 21, 2010 |
SQL SERVER – Change Database Access to Single User Mode Using SSMS |
| 1537 |
Nov 20, 2010 |
SQLAuthority News – Book Review – Beginning T-SQL 2008 by Kathi Kellenberger |
| 1536 |
Nov 19, 2010 |
SQLAuthority News – Blog Stats Revealed |
| 1535 |
Nov 18, 2010 |
SQLAuthority News – SQL Server Performance Series Hyderabad / Pune – Nov/Dec 2010 |
| 1534 |
Nov 17, 2010 |
SQL SERVER – History of SQL Server Database Encryption |
| 1533 |
Nov 16, 2010 |
SQLAuthority News – Download Whitepaper – Understanding and Controlling Parallel Query Processing in SQL Server |
| 1532 |
Nov 15, 2010 |
SQL SERVER – Information Related to DATETIME and DATETIME2 |
| 1531 |
Nov 14, 2010 |
SQL SERVER – ERROR – FIX – Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because it is currently in use |
| 1530 |
Nov 13, 2010 |
SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database |
| 1529 |
Nov 12, 2010 |
SQL SERVER – Get All the Information of Database using sys.databases |
| 1528 |
Nov 11, 2010 |
SQLAuthority News – SQL Server Denali CTP1 – Release Date November 9, 2010 |
| 1527 |
Nov 10, 2010 |
SQL SERVER – Get Database Backup History for a Single Database |
| 1526 |
Nov 09, 2010 |
SQL SERVER – Recycle Error Log – Create New Log file without Server Restart |
| 1525 |
Nov 08, 2010 |
SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2010 – Seattle |
| 1524 |
Nov 07, 2010 |
SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore |
| 1523 |
Nov 06, 2010 |
SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz |
| 1522 |
Nov 05, 2010 |
SQLAuthority News – Happy Deepavali and Happy News Year |
| 1521 |
Nov 04, 2010 |
SQL SERVER – Finding Last Backup Time for All Database |
| 1520 |
Nov 03, 2010 |
SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode. |
| 1519 |
Nov 02, 2010 |
SQL SERVER – Are you a Database Administrator or a Database Developer? |
| 1518 |
Nov 01, 2010 |
SQLAuthority News – 4th Birthday of Blog – 20 Million Views – Blog Anniversary – A Milestone |
| 1517 |
Oct 31, 2010 |
SQLAuthority News – New Banner of Blog |
| 1516 |
Oct 30, 2010 |
SQL SERVER – Minimum Maximum Memory – Server Memory Options |
| 1515 |
Oct 29, 2010 |
SQL SERVER – List of all the Views from Database |
| 1514 |
Oct 28, 2010 |
SQLAuthority News – Blog of Nupur Dave on Windows Live |
| 1513 |
Oct 27, 2010 |
SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage |
| 1512 |
Oct 26, 2010 |
SQLAuthority News – Database Performance for SharePoint Sites – Session Tomorrow in Singapore |
| 1511 |
Oct 25, 2010 |
SQL SERVER – A Brief Introduction to DW 2.0 |
| 1510 |
Oct 24, 2010 |
SQL SERVER – Corrupted Backup File and Unsuccessful Restore |
| 1509 |
Oct 23, 2010 |
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup |
| 1508 |
Oct 22, 2010 |
SQLAuthority News – SQLAuthority News – Presenting at South East Asia SharePoint Conference – Demo Details |
| 1507 |
Oct 21, 2010 |
SQLAuthority News – Book Review – Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners |
| 1506 |
Oct 20, 2010 |
SQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it |
| 1505 |
Oct 19, 2010 |
SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010 |
| 1504 |
Oct 18, 2010 |
SQL SERVER – Change Column DataTypes |
| 1503 |
Oct 17, 2010 |
SQL SERVER – System Stored Procedure sys.sp_tables |
| 1502 |
Oct 16, 2010 |
SQL SERVER – StreamInsight and SQL Server 2008 R2 |
| 1501 |
Oct 15, 2010 |
SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh |
| 1500 |
Oct 14, 2010 |
SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed |
| 1499 |
Oct 13, 2010 |
SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology |
| 1498 |
Oct 12, 2010 |
SQL SERVER – Indexed View always Use Index on Table |
| 1497 |
Oct 11, 2010 |
SQLAuthority News – Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site |
| 1496 |
Oct 10, 2010 |
SQL SERVER – Encrypted Stored Procedure and Activity Monitor |
| 1495 |
Oct 09, 2010 |
SQLAuthority News – SQL Server 2008 Add-ins and Feature Pack Downloads |
| 1494 |
Oct 08, 2010 |
SQL SERVER – Simple Explanation of Data Type Precedence |
| 1493 |
Oct 07, 2010 |
SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion |
| 1492 |
Oct 06, 2010 |
SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution |
| 1491 |
Oct 05, 2010 |
SQL SERVER – Error : Fix : Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.) |
| 1490 |
Oct 04, 2010 |
SQL SERVER – Find Total Number of Transaction on Interval |
| 1489 |
Oct 03, 2010 |
SQL SERVER – The Limitations of the Views – Eleven and more… |
| 1488 |
Oct 02, 2010 |
SQLAuthority News – SQL Server Seminar at Colombo Full – Hyderabad Few Seats Available |
| 1487 |
Oct 01, 2010 |
SQL SERVER – Get Query Running in Session |
| 1486 |
Sep 30, 2010 |
SQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download |
| 1485 |
Sep 30, 2010 |
SQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts |
| 1484 |
Sep 29, 2010 |
SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11 |
| 1483 |
Sep 28, 2010 |
SQLAuthority News – SQL Health Check and SQL Seminars |
| 1482 |
Sep 27, 2010 |
SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10 |
| 1481 |
Sep 26, 2010 |
SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9 |
| 1480 |
Sep 25, 2010 |
SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only |
| 1479 |
Sep 24, 2010 |
SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8 |
| 1478 |
Sep 23, 2010 |
SQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7 |
| 1477 |
Sep 22, 2010 |
SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6 |
| 1476 |
Sep 21, 2010 |
SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5 |
| 1475 |
Sep 20, 2010 |
SQL SERVER – How to Stop Growing Log File Too Big |
| 1474 |
Sep 19, 2010 |
SQL SERVER – SSRS 2008 R2 – MapGallery and Codeplex – World Map |
| 1473 |
Sep 18, 2010 |
SQL SERVER – 2008 R2 – PowerPivot for Microsoft Excel 2010 – RTM |
| 1472 |
Sep 17, 2010 |
SQLAuthority News – How to Subscribe to this Blog? |
| 1471 |
Sep 16, 2010 |
SQLAuthority News – What is an MVP? – How to become an MVP? |
| 1470 |
Sep 15, 2010 |
SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4 |
| 1469 |
Sep 14, 2010 |
SQL SERVER – Disabled Index and Index Levels and B-Tree |
| 1468 |
Sep 13, 2010 |
SQL SERVER – What are Wait Types, Wait Stats and its Importance |
| 1467 |
Sep 12, 2010 |
SQL SERVER – Soft Delete Conversation – Your Opinion Needed |
| 1466 |
Sep 11, 2010 |
SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper |
| 1465 |
Sep 10, 2010 |
SQL SERVER – Find Automatically Created Statistics – T-SQL |
| 1464 |
Sep 09, 2010 |
SQLAuthority News – Spicejet Complaint – Update – No Outcome |
| 1463 |
Sep 08, 2010 |
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2 |
| 1462 |
Sep 07, 2010 |
SQL SERVER – Index Levels and Delete Operations – Page Level Observation |
| 1461 |
Sep 06, 2010 |
SQL SERVER – Index Created on View not Used Often – Limitation of the View 3 |
| 1460 |
Sep 05, 2010 |
SQL SERVER – Few Notes on Fast Track Data Warehouse |
| 1459 |
Sep 04, 2010 |
SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me |
| 1458 |
Sep 03, 2010 |
SQL SERVER – Soft Delete – IsDelete Column – Your Opinion |
| 1457 |
Sep 02, 2010 |
SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server |
| 1456 |
Sep 01, 2010 |
SQLAuthority News – Fathers and Daughters |
| 1455 |
Aug 31, 2010 |
SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts – August 2010 |
| 1454 |
Aug 30, 2010 |
SQLAuthority News – SQL Server Performance Optimization – Seminar Series |
| 1453 |
Aug 29, 2010 |
SQLAuthority News – Download – SQL Server Monitoring Management Pack |
| 1452 |
Aug 28, 2010 |
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script |
| 1451 |
Aug 27, 2010 |
SQLAuthority News – Spicejet Complain – Do Not Fly with Spicejet |
| 1450 |
Aug 26, 2010 |
SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2 |
| 1449 |
Aug 25, 2010 |
SQL SERVER – Does Order of Column in WHERE clause Matter? |
| 1448 |
Aug 24, 2010 |
SQLAuthority News – Download Microsoft SQL Server Migration Assistant |
| 1447 |
Aug 24, 2010 |
SQLAuthority News – Feedback Received for Virtual Tech Days Sessions on Spatial Database |
| 1446 |
Aug 23, 2010 |
SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1 |
| 1445 |
Aug 22, 2010 |
SQL SERVER – Computed Columns – Index and Performance |
| 1444 |
Aug 21, 2010 |
SQL SERVER – Computed Column – PERSISTED and Storage – Part 2 |
| 1443 |
Aug 20, 2010 |
SQL SERVER – Function to Retrieve First Word of Sentence – String Operation |
| 1442 |
Aug 19, 2010 |
SQL SERVER – Negative Identity Seed Value and Negative Increment Interval |
| 1441 |
Aug 18, 2010 |
SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List |
| 1440 |
Aug 17, 2010 |
SQLAuthority News – Speaking Online at Virtual Techdays – Aug 18, 2010 – Spatial Datatypes |
| 1439 |
Aug 16, 2010 |
SQL SERVER – Finding the Occurrence of Character in String |
| 1438 |
Aug 15, 2010 |
SQLAuthority News – Bookmark Link for Sync Framework for SQL Azure |
| 1437 |
Aug 14, 2010 |
SQLAuthority News – Why SQL Server is better than any other RDBMS Applications? |
| 1436 |
Aug 13, 2010 |
SQL SERVER – Computed Column and Performance – Part 3 |
| 1435 |
Aug 12, 2010 |
SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server |
| 1434 |
Aug 11, 2010 |
SQLAuthority News – MSDN Subscription Giveaway Announced |
| 1433 |
Aug 10, 2010 |
SQL SERVER – Best Practices for DBA Before Taking Vacation |
| 1432 |
Aug 09, 2010 |
SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2 |
| 1431 |
Aug 09, 2010 |
SQLAuthority News – SQL Server Monitoring Management Pack Download |
| 1430 |
Aug 08, 2010 |
SQLAuthority News – Microsoft SQL Server 2008 R2 Report Builder 3.0 |
| 1429 |
Aug 07, 2010 |
SQLAuthority News – Community Tech Days, Ahmedabad – July 24, 2010 |
| 1428 |
Aug 06, 2010 |
SQL SERVER – Parallelism Query in Database |
| 1427 |
Aug 05, 2010 |
SQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success |
| 1426 |
Aug 04, 2010 |
SQL SERVER – Computed Column – PERSISTED and Performance – Part 2 |
| 1425 |
Aug 03, 2010 |
SQL SERVER – Computed Column – PERSISTED and Performance |
| 1424 |
Aug 02, 2010 |
SQLAuthority News – T-SQL Challenges and Hints and Suggestions |
| 1423 |
Aug 01, 2010 |
SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example |
| 1422 |
Jul 31, 2010 |
SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts |
| 1421 |
Jul 30, 2010 |
SQLAuthority News – Author’s Birthday – 5 SQL Server Best Practices |
| 1420 |
Jul 29, 2010 |
SQL SERVER – Check Advanced Server Configuration |
| 1419 |
Jul 28, 2010 |
SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010 |
| 1418 |
Jul 27, 2010 |
SQL SERVER – Computed Column – PERSISTED and Storage |
| 1417 |
Jul 26, 2010 |
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char |
| 1416 |
Jul 25, 2010 |
SQLAuthority News – Last 2 Day to Win MSDN Subscription – Total 2 to Win |
| 1415 |
Jul 24, 2010 |
SQLAuthority News – The story of the world – Spatial Data types – July 24, 2010 |
| 1414 |
Jul 24, 2010 |
SQL SERVER – Find Queries using Parallelism from Cached Plan |
| 1413 |
Jul 23, 2010 |
SQLAuthority News – Guest Post – Walkthrough on Creating WCF Data Service (ODATA) and Consuming in Windows 7 Mobile application |
| 1412 |
Jul 22, 2010 |
SQLAuthority News – SolidQ Journal Released – A Must Read for All |
| 1411 |
Jul 21, 2010 |
SQL SERVER – Win USD 11,899 worth MSDN Subscription 5 Days to go |
| 1410 |
Jul 20, 2010 |
SQL SERVER – SELECT * FROM dual – Dual Equivalent |
| 1409 |
Jul 19, 2010 |
SQL SERVER – Identifying Statistics Used by Query |
| 1408 |
Jul 18, 2010 |
SQLAuthority News – SQL Server Quickstart Downloads from Microsoft |
| 1407 |
Jul 17, 2010 |
SQLAuthority News – Community TechDays, Ahmedabad – July 24, 2010 |
| 1406 |
Jul 16, 2010 |
SQL SERVER – Datetime Function TODATETIMEOFFSET Example |
| 1405 |
Jul 15, 2010 |
SQL SERVER – Datetime Function SWITCHOFFSET Example |
| 1404 |
Jul 14, 2010 |
SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010 |
| 1403 |
Jul 13, 2010 |
SQL SERVER – How do I Learn and How do I Teach |
| 1402 |
Jul 12, 2010 |
SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN |
| 1401 |
Jul 11, 2010 |
SQL SERVER – Parallelism – Row per Processor – Row per Thread – Thread 0 |
| 1400 |
Jul 10, 2010 |
SQLAuthority News – Milestone – 1400th Post and Why do I blog |
| 1399 |
Jul 09, 2010 |
SQLAuthority News – I am a MVP and I Love SQL Server |
| 1398 |
Jul 08, 2010 |
SQL SERVER – The Self Join – Inner Join and Outer Join |
| 1397 |
Jul 07, 2010 |
SQL SERVER – Upper Case Shortcut SQL Server Management Studio |
| 1396 |
Jul 06, 2010 |
SQLAuthority News – I am Microsoft Certified Trainer (MCT) |
| 1395 |
Jul 05, 2010 |
SQL SERVER – PowerShell Version Info |
| 1394 |
Jul 04, 2010 |
SQL SERVER – Index Levels, Page Count, Record Count and DMV - sys.dm_db_index_physical_stats |
| 1393 |
Jul 03, 2010 |
SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan |
| 1392 |
Jul 02, 2010 |
SQL SERVER – Parallelism – Row per Processor – Row per Thread |
| 1391 |
Jul 01, 2010 |
SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial |
| 1390 |
Jun 30, 2010 |
SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts |
| 1389 |
Jun 29, 2010 |
SQL SERVER – Outer Join Not Allowed in Indexed Views |
| 1388 |
Jun 29, 2010 |
SQLAuthority News – Exam 70-433 – MCTS – Microsoft SQL Server 2008, Database Development |
| 1387 |
Jun 28, 2010 |
SQL SERVER – Default Statistics on Column – Automatic Statistics on Column |
| 1386 |
Jun 27, 2010 |
SQLAuthority News – Announcing Winners of the Office 2010 Giveaway |
| 1385 |
Jun 26, 2010 |
SQL SERVER – Fast Track Data Warehouse for SQL Server 2008 |
| 1384 |
Jun 25, 2010 |
SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer |
| 1383 |
Jun 24, 2010 |
SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life |
| 1382 |
Jun 23, 2010 |
SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian |
| 1381 |
Jun 22, 2010 |
SQLAuthority News – Price List – Oracle vs SQL Server |
| 1380 |
Jun 21, 2010 |
SQL SERVER – TRANSACTION, DML and Schema Locks |
| 1379 |
Jun 20, 2010 |
SQL SERVER – Free Download – SQL Server 2008 R2 Update for Developers Training Kit |
| 1378 |
Jun 19, 2010 |
SQLAuthority News – Delivering Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010 |
| 1377 |
Jun 18, 2010 |
SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver |
| 1376 |
Jun 17, 2010 |
SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache |
| 1375 |
Jun 16, 2010 |
SQL SERVER – Find Largest Supported DML Operation – Question to You |
| 1374 |
Jun 15, 2010 |
SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion |
| 1373 |
Jun 14, 2010 |
SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch |
| 1372 |
Jun 13, 2010 |
SQL SERVER – What is Denali? |
| 1371 |
Jun 12, 2010 |
SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE |
| 1370 |
Jun 11, 2010 |
SQL SERVER – Difference Between DATETIME and DATETIME2 |
| 1369 |
Jun 10, 2010 |
SQL SERVER – Difference Between GETDATE and SYSDATETIME |
| 1368 |
Jun 09, 2010 |
SQL SERVER – Fastest Way to Restore the Database |
| 1367 |
Jun 08, 2010 |
SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution |
| 1366 |
Jun 07, 2010 |
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2 |
| 1365 |
Jun 06, 2010 |
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best |
| 1364 |
Jun 05, 2010 |
SQL SERVER – Convert IN to EXISTS – Performance Talk |
| 1363 |
Jun 04, 2010 |
SQL SERVER – Generate Database Script for SQL Azure |
| 1362 |
Jun 03, 2010 |
SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days |
| 1361 |
Jun 02, 2010 |
SQL SERVER – Stored Procedure and Transactions |
| 1360 |
Jun 01, 2010 |
SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision |
| 1359 |
May 31, 2010 |
SQLAuthority News – Monthly Roundup of Best SQL Posts |
| 1358 |
May 30, 2010 |
SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell |
| 1357 |
May 29, 2010 |
SQLAuthority News – Guest Post – FAULT Contract in WCF with Learning Video |
| 1356 |
May 28, 2010 |
SQL SERVER – Disabled Index and Update Statistics |
| 1355 |
May 27, 2010 |
SQL SERVER – DATE and TIME in SQL Server 2008 |
| 1354 |
May 26, 2010 |
SQLAuthority News – SQL Server Technology Evangelists and Evangelism |
| 1353 |
May 26, 2010 |
SQLAuthority News – Win MS Office License – Last 2 days |
| 1352 |
May 25, 2010 |
SQLAuthority News – Whitepaper – SQL Azure vs. SQL Server |
| 1351 |
May 24, 2010 |
SQLAuthority News – Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010 |
| 1350 |
May 24, 2010 |
SQL SERVER – Check the Isolation Level with DBCC useroptions |
| 1349 |
May 23, 2010 |
SQLAuthority News – Virtual Launch Event for Office 2010 – Contest – Win MS Office License |
| 1348 |
May 22, 2010 |
SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5 |
| 1347 |
May 21, 2010 |
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions |
| 1346 |
May 20, 2010 |
SQLAuthority News – Professional Development and Community |
| 1345 |
May 19, 2010 |
SQLAuthority News – Updated Favorite Scripts and Best Articles Page |
| 1344 |
May 18, 2010 |
SQLAuthority Book Review – DBA Survivor: Become a Rock Star DBA |
| 1343 |
May 17, 2010 |
SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008 |
| 1342 |
May 16, 2010 |
SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010 |
| 1341 |
May 15, 2010 |
SQL SERVER – List All the DMV and DMF on Server |
| 1340 |
May 14, 2010 |
SQL SERVER – Find Most Expensive Queries Using DMV |
| 1339 |
May 13, 2010 |
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup |
| 1338 |
May 12, 2010 |
SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index |
| 1337 |
May 11, 2010 |
SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006 |
| 1336 |
May 10, 2010 |
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell |
| 1335 |
May 09, 2010 |
SQL SERVER – Size of Index Table for Each Index – Solution 2 |
| 1334 |
May 08, 2010 |
SQLAuthority News – MSDN Flash Mentions – TechNet Flash Mention – Top Community Contributors (Annual) Winner |
| 1333 |
May 07, 2010 |
SQLAuthority News – List of Master Data Services White Paper |
| 1332 |
May 06, 2010 |
SQLAuthority News – SQL Server 2008 R2 Hosted Trial |
| 1331 |
May 06, 2010 |
SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password |
| 1330 |
May 05, 2010 |
SQL SERVER – Get Latest SQL Query for Sessions – DMV |
| 1329 |
May 04, 2010 |
SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training |
| 1328 |
May 03, 2010 |
SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008 |
| 1327 |
May 02, 2010 |
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo |
| 1326 |
May 01, 2010 |
SQL SERVER – What is AdventureWorks? |
| 1325 |
Apr 30, 2010 |
SQLAuthority News – TechEd India – April 12-14, 2010 Bangalore – An Unforgettable Experience – An Opportunity of A Lifetime |
| 1324 |
Apr 29, 2010 |
SQL SERVER – Disable Clustered Index and Data Insert |
| 1323 |
Apr 28, 2010 |
SQL SERVER – GUID vs INT – Your Opinion |
| 1322 |
Apr 27, 2010 |
SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint |
| 1321 |
Apr 26, 2010 |
SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning |
| 1320 |
Apr 26, 2010 |
SQL SERVER – Attach mdf file without ldf file in Database |
| 1319 |
Apr 25, 2010 |
SQLAuthority News – Free Download – Microsoft SQL Server 2008 R2 RTM – Express with Management Tools – SQL Server 2008 R2 Books Online |
| 1318 |
Apr 24, 2010 |
SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online |
| 1317 |
Apr 23, 2010 |
SQL SERVER – Update Statistics are Sampled By Default |
| 1316 |
Apr 22, 2010 |
SQL SERVER – Create Primary Key with Specific Name when Creating Table |
| 1315 |
Apr 21, 2010 |
SQL SERVER – When are Statistics Updated – What triggers Statistics to Update |
| 1314 |
Apr 20, 2010 |
SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit |
| 1313 |
Apr 19, 2010 |
SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats |
| 1312 |
Apr 18, 2010 |
SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2 |
| 1311 |
Apr 17, 2010 |
SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS) |
| 1310 |
Apr 16, 2010 |
SQLAuthority News – Best Complements – DBA Survivor: Become a Rock Star DBA |
| 1309 |
Apr 15, 2010 |
SQLAuthority News – Tips for Traveling to Nepal |
| 1308 |
Apr 14, 2010 |
SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing |
| 1307 |
Apr 13, 2010 |
SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005 |
| 1306 |
Apr 13, 2010 |
SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005 |
| 1305 |
Apr 12, 2010 |
SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2 |
| 1304 |
Apr 11, 2010 |
SQLAuthority News – Spot the SQLAuthority Baby Contest – SQL Server Cheat Sheet |
| 1303 |
Apr 10, 2010 |
SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion |
| 1302 |
Apr 09, 2010 |
SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience |
| 1301 |
Apr 08, 2010 |
SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010 |
| 1300 |
Apr 07, 2010 |
SQLAuthority News – Milestone of 1300th Post and A Few Updates |
| 1299 |
Apr 06, 2010 |
SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database |
| 1298 |
Apr 05, 2010 |
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot |
| 1297 |
Apr 04, 2010 |
SQL SERVER – Enable Identity Insert – Import Expert Wizard |
| 1296 |
Apr 03, 2010 |
SQL SERVER – Difference Between GRANT and WITH GRANT |
| 1295 |
Apr 02, 2010 |
SQL SERVER – Simple Installation of Master Data Services (MDS) and Sample Packages – Very Easy |
| 1294 |
Apr 01, 2010 |
SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor |
| 1293 |
Mar 31, 2010 |
SQLAuthority News – SQL Server Cheat Sheet from MidnightDBA |
| 1292 |
Mar 30, 2010 |
SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database |
| 1291 |
Mar 29, 2010 |
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries |
| 1290 |
Mar 28, 2010 |
SQLAuthority News – Author Visit to Nepal TechMela – 2 Technical Sessions |
| 1289 |
Mar 27, 2010 |
SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup |
| 1288 |
Mar 26, 2010 |
SQL SERVER – Generate Report for Index Physical Statistics – SSMS |
| 1287 |
Mar 25, 2010 |
SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS |
| 1286 |
Mar 24, 2010 |
SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase |
| 1285 |
Mar 23, 2010 |
SQLAuthority News – We’re sorry… … but your computer or network may be sending automated queries. To protect our users, we can’t process your request right now. |
| 1284 |
Mar 22, 2010 |
SQL SERVER – Enumerations in Relational Database – Best Practice |
| 1283 |
Mar 21, 2010 |
SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward |
| 1282 |
Mar 20, 2010 |
SQLAuthority News – Microsoft SQL Server Protocol Documentation Download |
| 1281 |
Mar 19, 2010 |
SQL SERVER – Interview Questions & Answers Needs Your Help |
| 1280 |
Mar 18, 2010 |
SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist |
| 1279 |
Mar 17, 2010 |
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE |
| 1278 |
Mar 16, 2010 |
SQL SERVER – Quick Note of Database Mirroring |
| 1277 |
Mar 15, 2010 |
SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU |
| 1276 |
Mar 14, 2010 |
SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You |
| 1275 |
Mar 13, 2010 |
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update) |
| 1274 |
Mar 13, 2010 |
SQLAuthority News – Download Microsoft SQL Server JDBC Driver 3.0 CTP 1 |
| 1273 |
Mar 12, 2010 |
SQL SERVER – Checklist for Analyzing Slow-Running Queries |
| 1272 |
Mar 11, 2010 |
SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint |
| 1271 |
Mar 10, 2010 |
SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting |
| 1270 |
Mar 09, 2010 |
SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index |
| 1269 |
Mar 08, 2010 |
SQLAuthority News – SQL SERVER 2008 R2 Pricing |
| 1268 |
Mar 07, 2010 |
SQLAuthority News – Office 2010 Readiness Check – Are you ready for Office 2010? |
| 1267 |
Mar 06, 2010 |
SQLAuthority News – SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo) |
| 1266 |
Mar 05, 2010 |
SQL SERVER – Order of Columns in Update Statement Does not Matter |
| 1265 |
Mar 04, 2010 |
SQL SERVER – Rollback TRUNCATE Command in Transaction |
| 1264 |
Mar 03, 2010 |
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT |
| 1263 |
Mar 02, 2010 |
SQLAuthority News – Excellent Event – TechEd Sri Lanka – Feb 8, 2010 |
| 1262 |
Mar 01, 2010 |
SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement |
| 1261 |
Feb 28, 2010 |
SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance |
| 1260 |
Feb 27, 2010 |
SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT |
| 1259 |
Feb 26, 2010 |
SQLAuthority News – Keeping Your Ducks in a Row |
| 1258 |
Feb 25, 2010 |
SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review |
| 1257 |
Feb 24, 2010 |
SQL SERVER – Introduction to Rollup Clause |
| 1256 |
Feb 23, 2010 |
SQLAuthority News – Links to Book On Line – Data Mining Algorithms (Analysis Services – Data Mining) |
| 1255 |
Feb 22, 2010 |
SQLAuthority News – Blog Subscription and Comments RSS |
| 1254 |
Feb 21, 2010 |
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table) |
| 1253 |
Feb 20, 2010 |
SQL SERVER – Recompile Stored Procedure at Run Time |
| 1252 |
Feb 19, 2010 |
SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1 |
| 1251 |
Feb 18, 2010 |
SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning |
| 1250 |
Feb 17, 2010 |
SQLAuthority News – SQL Server Technical Article – The Data Loading Performance Guide |
| 1249 |
Feb 16, 2010 |
SQL SERVER – Stored Procedure Optimization Tips – Best Practices |
| 1248 |
Feb 15, 2010 |
SQL SERVER – Difference Between Update Lock and Exclusive Lock |
| 1247 |
Feb 14, 2010 |
SQLAuthority News – SuperFlow for Creating SRS Report Models in Configuration Manager 2007 |
| 1246 |
Feb 13, 2010 |
SQLAuthority News – Download SQL Server 2008 Express Datasheet |
| 1245 |
Feb 12, 2010 |
SQLAuthority News – Ahmedabad Community Tech Days – Jan 30, 2010 – Huge Success |
| 1244 |
Feb 11, 2010 |
SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE |
| 1243 |
Feb 10, 2010 |
SQLAuthority News – Converting a Delimited String of Values into Columns |
| 1242 |
Feb 09, 2010 |
SQL SERVER – Brief Note about StreamInsight – What is StreamInsight |
| 1241 |
Feb 08, 2010 |
SQL SERVER – Find the Size of Database File – Find the Size of Log File |
| 1240 |
Feb 07, 2010 |
SQL SERVER – SQL Server 2008 R2 Update for Developers Training Kit |
| 1239 |
Feb 06, 2010 |
SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka |
| 1238 |
Feb 05, 2010 |
SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate |
| 1237 |
Feb 04, 2010 |
SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines and sys.dm_sql_referencing_entities |
| 1236 |
Feb 03, 2010 |
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun |
| 1235 |
Feb 02, 2010 |
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business |
| 1234 |
Feb 01, 2010 |
SQL SERVER – Question – How to Convert Hex to Decimal |
| 1233 |
Jan 31, 2010 |
SQL SERVER – Location of Resource Database in SQL Server Editions |
| 1232 |
Jan 30, 2010 |
SQL SERVER – Several Readers Questions and Readers Answers |
| 1231 |
Jan 29, 2010 |
SQLAuthority News – Microsoft in India – Leadership Profiles |
| 1230 |
Jan 28, 2010 |
SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend |
| 1229 |
Jan 27, 2010 |
SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010 |
| 1228 |
Jan 26, 2010 |
SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008 |
| 1227 |
Jan 25, 2010 |
SQL SERVER – Find Statistics Update Date – Update Statistics |
| 1226 |
Jan 24, 2010 |
SQLAuthority News – Download Sample Databases for Microsoft SQL Server 2008 (December 2009) Samples Refresh 4 |
| 1225 |
Jan 23, 2010 |
SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification |
| 1224 |
Jan 22, 2010 |
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit |
| 1223 |
Jan 21, 2010 |
SQLAuthority News – Community Tech Days – Jan 30, 2010 – Event Announcement |
| 1222 |
Jan 20, 2010 |
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 |
| 1221 |
Jan 19, 2010 |
SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results |
| 1220 |
Jan 18, 2010 |
SQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action |
| 1219 |
Jan 17, 2010 |
SQL SERVER – Get Server Version and Additional Info |
| 1218 |
Jan 16, 2010 |
SQLAuthority News – Download Windows Azure Platform Training Kit – December Update |
| 1217 |
Jan 15, 2010 |
SQL SERVER – Initializing a Merge Subscription Without a Snapshot |
| 1216 |
Jan 15, 2010 |
SQLAuthority News – Vote for SQL Server 2005 Service Pack 4 – Vote for SQL Server 2008 Service Pack 2 |
| 1215 |
Jan 14, 2010 |
SQL SERVER – Find Busiest Database |
| 1214 |
Jan 13, 2010 |
SQLAuthority News – SQL Server Migration QuickStart |
| 1213 |
Jan 12, 2010 |
SQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation |
| 1212 |
Jan 11, 2010 |
SQL SERVER – The server network address “TCP://SQLServer:5023″ can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418) |
| 1211 |
Jan 10, 2010 |
SQLAuthority News – Download – Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit) |
| 1210 |
Jan 09, 2010 |
SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1 |
| 1209 |
Jan 08, 2010 |
SQLAuthority News – Ahmedabad – Gandhinagar SQL Server User Group Meet – Dec 19, 2009 |
| 1208 |
Jan 07, 2010 |
SQLAuthority News – Webcasts – Resources for IT Managers and their Teams |
| 1207 |
Jan 06, 2010 |
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior |
| 1206 |
Jan 05, 2010 |
SQL SERVER – SQL Server RDL Specification |
| 1205 |
Jan 05, 2010 |
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database |
| 1204 |
Jan 04, 2010 |
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON |
| 1203 |
Jan 03, 2010 |
SQLAuthority News – TechDays Session at Infosys Mysore 2009 – Change Data Capture and PowerPivot |
| 1202 |
Jan 02, 2010 |
SQL SERVER – Find Location of Data File Using T-SQL |
| 1201 |
Jan 01, 2010 |
SQL SERVER – FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later. |
| 1200 |
Dec 31, 2009 |
SQLAuthority News – 1200th Post – An Important Milestone |
| 1199 |
Dec 30, 2009 |
SQL SERVER – FIX : Error : Msg 1949, Level 16: Cannot create index on view. The function yields nondeterministic results. Use a deterministic system function, or modify the user-defined function to return deterministic results. |
| 1198 |
Dec 29, 2009 |
SQL SERVER – Get Date of All Weekdays or Weekends of the Year |
| 1197 |
Dec 28, 2009 |
SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction |
| 1196 |
Dec 27, 2009 |
SQL SERVER – Download FREE SQL SERVER Express Edition and Service Pack 1 |
| 1195 |
Dec 26, 2009 |
SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements |
| 1194 |
Dec 25, 2009 |
SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture |
| 1193 |
Dec 24, 2009 |
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning |
| 1192 |
Dec 23, 2009 |
SQL SERVER – ORDER BY Clause and TOP WITH TIES |
| 1191 |
Dec 22, 2009 |
SQLAuthority News – Meeting SQL Expert Imran at Hyderabad |
| 1190 |
Dec 21, 2009 |
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 |
| 1189 |
Dec 20, 2009 |
SQLAuthority News – Migrating DTS Packages to Integration Services |
| 1188 |
Dec 19, 2009 |
SQLAuthority News – Migrating to SQL Server from Other Database Products |
| 1187 |
Dec 18, 2009 |
SQL SERVER – Differences in Vulnerability between Oracle and SQL Server |
| 1186 |
Dec 17, 2009 |
SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation |
| 1185 |
Dec 16, 2009 |
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance |
| 1184 |
Dec 15, 2009 |
SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth |
| 1183 |
Dec 14, 2009 |
SQLAuthority News – An Year of Personal Events – A Life Outside SQL |
| 1182 |
Dec 13, 2009 |
SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008 |
| 1181 |
Dec 12, 2009 |
SQLAuthority News – Featured on Channel 9 |
| 1180 |
Dec 11, 2009 |
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication |
| 1179 |
Dec 10, 2009 |
SQL SERVER – Future of Business Intelligence |
| 1178 |
Dec 09, 2009 |
SQL SERVER – Business Intelligence – Aligning Business Metrics |
| 1177 |
Dec 08, 2009 |
SQL SERVER – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208) |
| 1176 |
Dec 07, 2009 |
SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman |
| 1175 |
Dec 06, 2009 |
SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008 |
| 1174 |
Dec 05, 2009 |
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore |
| 1173 |
Dec 04, 2009 |
SQL SERVER – 2008 Star Join Query Optimization |
| 1172 |
Dec 03, 2009 |
SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet |
| 1171 |
Dec 02, 2009 |
SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian |
| 1170 |
Dec 01, 2009 |
SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew |
| 1169 |
Nov 30, 2009 |
SQL SERVER – Size of Index Table for Each Index – Solution |
| 1168 |
Nov 29, 2009 |
SQL SERVER – Azure Start Guide – Step by Step Installation Guide |
| 1167 |
Nov 28, 2009 |
SQLAuthority News – SQL Server R2 Resources Downloads, Documentations |
| 1166 |
Nov 27, 2009 |
SQLAuthority News – Subscribe to Blog – Search a Blog |
| 1165 |
Nov 26, 2009 |
SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide |
| 1164 |
Nov 25, 2009 |
SQL SERVER – Comma Separated Values (CSV) from Table Column |
| 1163 |
Nov 24, 2009 |
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY |
| 1162 |
Nov 23, 2009 |
SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index |
| 1161 |
Nov 22, 2009 |
SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas |
| 1160 |
Nov 21, 2009 |
SQLAuthority News – SQL Server 2008 for Oracle DBA |
| 1159 |
Nov 20, 2009 |
SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles |
| 1158 |
Nov 19, 2009 |
SQL SERVER – Understanding Table Hints with Examples |
| 1157 |
Nov 18, 2009 |
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table |
| 1156 |
Nov 17, 2009 |
SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren |
| 1155 |
Nov 16, 2009 |
SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle |
| 1154 |
Nov 15, 2009 |
SQL SERVER – Whitepaper Consolidation Using SQL Server 2008 |
| 1153 |
Nov 14, 2009 |
SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server |
| 1152 |
Nov 13, 2009 |
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies |
| 1151 |
Nov 12, 2009 |
SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint |
| 1150 |
Nov 11, 2009 |
SQL SERVER – Sharepoint Resource Available for SQL Server |
| 1149 |
Nov 10, 2009 |
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning |
| 1148 |
Nov 09, 2009 |
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes |
| 1147 |
Nov 08, 2009 |
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time |
| 1146 |
Nov 07, 2009 |
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices |
| 1145 |
Nov 06, 2009 |
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4 |
| 1144 |
Nov 05, 2009 |
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3 |
| 1143 |
Nov 04, 2009 |
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2 |
| 1142 |
Nov 03, 2009 |
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1 |
| 1141 |
Nov 02, 2009 |
SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views |
| 1140 |
Nov 01, 2009 |
SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors |
| 1139 |
Oct 31, 2009 |
SQLAuthority News – New PASS President Rushabh Mehta |
| 1138 |
Oct 30, 2009 |
SQLAuthority News – India Market and Third Party SQL Server Tools |
| 1137 |
Oct 29, 2009 |
SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009 |
| 1136 |
Oct 28, 2009 |
SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008 |
| 1135 |
Oct 27, 2009 |
SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’ |
| 1134 |
Oct 26, 2009 |
SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True |
| 1133 |
Oct 25, 2009 |
SQLAuthority News – Best Practices for Integration Services Configurations |
| 1132 |
Oct 24, 2009 |
SQL SERVER – Link to SQL Server Book Online – BOL |
| 1131 |
Oct 23, 2009 |
SQLAuthority News – PASS Sessions – I will be there! |
| 1130 |
Oct 22, 2009 |
SQL SERVER – Difference Between Candidate Keys and Primary Key |
| 1129 |
Oct 21, 2009 |
SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions |
| 1128 |
Oct 20, 2009 |
SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning |
| 1127 |
Oct 19, 2009 |
SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script |
| 1126 |
Oct 18, 2009 |
SQLAuthority News – Whitepaper – Auditing in SQL Server 2008 |
| 1125 |
Oct 17, 2009 |
SQLAuthority News – Happy Diwali and New Year |
| 1124 |
Oct 16, 2009 |
SQL SERVER – Recently Executed T-SQL Query |
| 1123 |
Oct 15, 2009 |
SQL SERVER – Enable Automatic Statistic Update on Database |
| 1122 |
Oct 14, 2009 |
SQLAuthority News – First Editorial – T-SQL Challenges Beginners |
| 1121 |
Oct 13, 2009 |
SQL SERVER – Comic Slow Query – SQL Joke |
| 1120 |
Oct 12, 2009 |
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3 |
| 1119 |
Oct 11, 2009 |
SQLAuthority News – Accessing SQL Server Databases with PHP |
| 1118 |
Oct 10, 2009 |
SQL SERVER – Download Logical Query Processing Poster |
| 1117 |
Oct 09, 2009 |
SQL SERVER – Queries Waiting for Memory Allocation to Execute |
| 1116 |
Oct 08, 2009 |
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2 |
| 1115 |
Oct 07, 2009 |
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup |
| 1114 |
Oct 06, 2009 |
SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER |
| 1113 |
Oct 05, 2009 |
SQLAuthority News – Community TechDays in Ahmedabad – A Successful Event – Oct 3, 2009 |
| 1112 |
Oct 04, 2009 |
SQL SERVER – Choose Right Edition of SQL Server Express for Your Application |
| 1111 |
Oct 03, 2009 |
SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition |
| 1110 |
Oct 02, 2009 |
SQLAuthority News – SQL Server 2008 – The Other Side of Index – Live Presentation in Ahmedabad |
| 1109 |
Oct 01, 2009 |
SQL SERVER – SQL Server Management Studio and Client Statistics |
| 1108 |
Sep 30, 2009 |
SQLAuthority News – Community Tech Days – Oct 3, 2009 – SQL Server 2008 – The Other Side of Index |
| 1107 |
Sep 29, 2009 |
SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries |
| 1106 |
Sep 28, 2009 |
SQLAuthority News – Download IIS Database Manager |
| 1105 |
Sep 27, 2009 |
SQLAuthority News – FILESTREAM Storage in SQL Server 2008 |
| 1104 |
Sep 26, 2009 |
SQLAuthority News – FIX : An error occurred while executing this command. If this error persists, please contact your Live Meeting administrator. |
| 1103 |
Sep 25, 2009 |
SQL SERVER – Outer Join in Indexed View – Question to Readers |
| 1102 |
Sep 24, 2009 |
SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query |
| 1101 |
Sep 23, 2009 |
SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function |
| 1100 |
Sep 22, 2009 |
SQLAuthority News – Article 1100 and Community Service |
| 1099 |
Sep 21, 2009 |
SQL SERVER – Intorduction to Service Broker and Sample Script |
| 1098 |
Sep 20, 2009 |
SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location |
| 1097 |
Sep 19, 2009 |
SQLAuthority News – SQL Server Accelerator for Business Intelligence (BI) |
| 1096 |
Sep 18, 2009 |
SQLAuthority News – Community Tech Days Oct 3, 2009 – Ahmedabad |
| 1095 |
Sep 17, 2009 |
SQL SERVER – Converting Stored Procedure into Table Valued Function |
| 1094 |
Sep 16, 2009 |
SQLAuthority News – Download Microsoft SQL Server StreamInsight CTP2 |
| 1093 |
Sep 15, 2009 |
SQL SERVER – Cryptography in SQL Server 2008 |
| 1092 |
Sep 14, 2009 |
SQL SERVER – Plan Caching and Schema Change – An Interesting Observation |
| 1091 |
Sep 13, 2009 |
SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet |
| 1090 |
Sep 12, 2009 |
SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2 |
| 1089 |
Sep 11, 2009 |
SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2009- Seattle |
| 1088 |
Sep 10, 2009 |
SQL SERVER – SQL Server Desktop Screen Background |
| 1087 |
Sep 09, 2009 |
SQL SERVER – Difference between SQL Server Express and MySQL |
| 1086 |
Sep 08, 2009 |
SQLAuthority News – Shaivi Dave – Baby SQLAuthority |
| 1085 |
Sep 07, 2009 |
SQL SERVER – Importance of Database Schemas in SQL Server |
| 1084 |
Sep 06, 2009 |
SQL SERVER – Find Gaps in The Sequence |
| 1083 |
Sep 05, 2009 |
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724) |
| 1082 |
Sep 04, 2009 |
SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables |
| 1081 |
Sep 03, 2009 |
SQL SERVER – What is Data Mining – A Simple Introductory Note |
| 1080 |
Sep 02, 2009 |
SQL SERVER – Mirrored Backup and Restore and Split File Backup |
| 1079 |
Sep 01, 2009 |
SQL SERVER – Download Script of Change Data Capture (CDC) |
| 1078 |
Sep 01, 2009 |
SQLAuthority News – Baby SQLAuthority is here! |
| 1077 |
Aug 31, 2009 |
SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis |
| 1076 |
Aug 30, 2009 |
SQLAuthority News – Application and Multi-Server Management |
| 1075 |
Aug 29, 2009 |
SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low |
| 1074 |
Aug 28, 2009 |
SQL SERVER – Best Practices – Implementation of Database Object Schemas |
| 1073 |
Aug 27, 2009 |
SQL SERVER – Introduction to SQL Azure |
| 1072 |
Aug 26, 2009 |
SQL SERVER – SQL Server Express – A Complete Reference Guide |
| 1071 |
Aug 25, 2009 |
SQLAuthority News – Business Intelligence Training Roadshow August September 2009 |
| 1070 |
Aug 24, 2009 |
SQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note |
| 1069 |
Aug 23, 2009 |
SQLAuthority News – SQL Server 2008 Migration White Papers |
| 1068 |
Aug 22, 2009 |
SQLAuthority News – Microsoft SQL Server 2008 Books Online |
| 1067 |
Aug 21, 2009 |
SQL SERVER – Get Query Plan Along with Query Text and Execution Count |
| 1066 |
Aug 20, 2009 |
SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. |
| 1065 |
Aug 19, 2009 |
SQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online |
| 1064 |
Aug 18, 2009 |
SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational |
| 1063 |
Aug 17, 2009 |
SQL SERVER – Measure CPU Pressure – CPU Business |
| 1062 |
Aug 16, 2009 |
SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP) |
| 1061 |
Aug 15, 2009 |
SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008 |
| 1060 |
Aug 14, 2009 |
SQLAuthority News – USB Drive Fails to Copy Large File |
| 1059 |
Aug 13, 2009 |
SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service |
| 1058 |
Aug 12, 2009 |
SQL SERVER – Backup master Database Interval – master Database Best Practices |
| 1057 |
Aug 11, 2009 |
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario |
| 1056 |
Aug 10, 2009 |
SQLAuthority News – A Quick Guide to Twitter |
| 1055 |
Aug 09, 2009 |
SQLAuthority News – Interview with SQL Server MVP Glenn Berry |
| 1054 |
Aug 08, 2009 |
SQL Server – Multiple CTE in One SELECT Statement Query |
| 1053 |
Aug 07, 2009 |
SQLAuthority News – Humorous SQL Cake – Funny SQL Cake |
| 1052 |
Aug 06, 2009 |
SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime |
| 1051 |
Aug 05, 2009 |
SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server |
| 1050 |
Aug 04, 2009 |
SQL SERVER – Forgot the Password of Username SA |
| 1049 |
Aug 04, 2009 |
SQLAuthority News – Author Visit – Virtual Tech Days August 2009 |
| 1048 |
Aug 03, 2009 |
SQL SERVER – Introduction to SQL Server 2008 Profiler |
| 1047 |
Aug 02, 2009 |
SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few |
| 1046 |
Aug 01, 2009 |
SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007 |
| 1045 |
Jul 31, 2009 |
SQL SERVER – Introduction to Cloud Computing |
| 1044 |
Jul 30, 2009 |
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers |
| 1043 |
Jul 29, 2009 |
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table |
| 1042 |
Jul 28, 2009 |
SQL SERVER – 2008 – Design Process Decision Flow |
| 1041 |
Jul 27, 2009 |
SQL SERVER – List All Missing Identity Values of Table in Database |
| 1040 |
Jul 26, 2009 |
SQLAuthority News – Search SQL Server Solutions |
| 1039 |
Jul 25, 2009 |
SQLAuthority News – Download – Cumulative Update Package for SQL Server 2008 |
| 1038 |
Jul 24, 2009 |
SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen |
| 1037 |
Jul 23, 2009 |
SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key |
| 1036 |
Jul 22, 2009 |
SQLAuthority News – SQL Server Value Calculator |
| 1035 |
Jul 21, 2009 |
SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing |
| 1034 |
Jul 20, 2009 |
SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009 |
| 1033 |
Jul 19, 2009 |
SQL SERVER – Get Last Running Query Based on SPID |
| 1032 |
Jul 18, 2009 |
SQLAuthority News – Whitepaper – Using the Resource Governor |
| 1031 |
Jul 17, 2009 |
SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database |
| 1030 |
Jul 16, 2009 |
SQL SERVER – Four Different Ways to Find Recovery Model for Database |
| 1029 |
Jul 15, 2009 |
SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY |
| 1028 |
Jul 14, 2009 |
SQL SERVER – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model |
| 1027 |
Jul 13, 2009 |
SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage |
| 1026 |
Jul 12, 2009 |
SQLAuthority News – Big Thinkers – Robert Cain |
| 1025 |
Jul 11, 2009 |
SQL SERVER – Standby Servers and Types of Standby Servers |
| 1024 |
Jul 10, 2009 |
SQLAuthority News – Request SQLAuthority.com Stickers and SQL Server Cheat Sheet |
| 1023 |
Jul 09, 2009 |
SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009 |
| 1022 |
Jul 08, 2009 |
SQLAuthority News – Book Review – Murach’s SQL Server 2008 for Developers |
| 1021 |
Jul 07, 2009 |
SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009 |
| 1020 |
Jul 06, 2009 |
SQL SERVER – Languages for BI – MDX, DMX, XMLA |
| 1019 |
Jul 05, 2009 |
SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades |
| 1018 |
Jul 04, 2009 |
SQL SERVER – Disk Partition Alignment Best Practices |
| 1017 |
Jul 03, 2009 |
SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides) |
| 1016 |
Jul 02, 2009 |
SQLAuthority News – MVP Award Renewed |
| 1015 |
Jul 01, 2009 |
SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char |
| 1014 |
Jun 30, 2009 |
SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies |
| 1013 |
Jun 29, 2009 |
SQL SERVER – Maximum Number of Index per Table |
| 1012 |
Jun 28, 2009 |
SQL SERVER – 2008 – Management Studio New Features |
| 1011 |
Jun 27, 2009 |
SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’. |
| 1010 |
Jun 26, 2009 |
SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution |
| 1009 |
Jun 25, 2009 |
SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009 |
| 1008 |
Jun 24, 2009 |
SQLAuthority News – Update on pinaldave.com and SQLAuthority.com |
| 1007 |
Jun 23, 2009 |
SQL SERVER – 2005 – 2008 – Delete Duplicate Rows |
| 1006 |
Jun 22, 2009 |
SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success |
| 1005 |
Jun 21, 2009 |
SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1 |
| 1004 |
Jun 20, 2009 |
SQL Server – Understanding Table Hints with Examples |
| 1003 |
Jun 19, 2009 |
SQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle |
| 1002 |
Jun 18, 2009 |
SQL SERVER – Clustered Index on Separate Drive From Table Location |
| 1001 |
Jun 17, 2009 |
SQL SERVER – List Schema Name and Table Name for Database |
| 1000 |
Jun 16, 2009 |
SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors |
| 999 |
Jun 15, 2009 |
SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You |
| 998 |
Jun 14, 2009 |
SQL SERVER – 2008 – SSMS Feature – Multi-server Queries |
| 997 |
Jun 13, 2009 |
SQL SERVER – Effect of Normalization on Index and Performance |
| 996 |
Jun 12, 2009 |
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar |
| 995 |
Jun 11, 2009 |
SQLAuthority News – Registration and Competition – TechEd on Road – Ahmedabad – June 20, 2009 Saturday |
| 994 |
Jun 10, 2009 |
SQL SERVER – Performance Counters from System Views – By Kevin Mckenna |
| 993 |
Jun 09, 2009 |
SQLAuthority News – TechEd On Road Ahmedabad, India is Announced – June 20, 2009 Saturday |
| 992 |
Jun 08, 2009 |
SQL SERVER – Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed |
| 991 |
Jun 07, 2009 |
SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias |
| 990 |
Jun 06, 2009 |
SQL SERVER – Order of Hotfix and Service Pack |
| 989 |
Jun 05, 2009 |
SQLAuthority News – Rambling of Author and Technology Musing – Bing, Google, Windows 7, Books, Blogs, Twitter and Life |
| 988 |
Jun 04, 2009 |
SQL SERVER – What is Interim Table – Simple Definition of Interim Table |
| 987 |
Jun 03, 2009 |
SQL SERVER – Connect Item – Vote for Feature Request Function TRIM |
| 986 |
Jun 02, 2009 |
SQLAuthority News – Summary of TechEd India 2009 – A Grand Event |
| 985 |
Jun 01, 2009 |
SQL SERVER – List All Objects Created on All Filegroups in Database |
| 984 |
May 31, 2009 |
SQL SERVER – Create Multiple Filegroup For Single Database |
| 983 |
May 30, 2009 |
SQL SERVER – Difference Between Candidate Keys and Primary Key |
| 982 |
May 29, 2009 |
SQLAuthority News – Blog Makeover – New Banner – New Color |
| 981 |
May 28, 2009 |
SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer |
| 980 |
May 27, 2009 |
SQL SERVER – Interesting Observation of Logon Trigger On All Servers |
| 979 |
May 26, 2009 |
SQL SERVER – Find Hostname and Current Logged In User Name |
| 978 |
May 25, 2009 |
SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (May 2009) |
| 977 |
May 24, 2009 |
SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions |
| 976 |
May 23, 2009 |
SQLAuthority News – SQL Server Energy Event with Rushabh Mehta – May 20, 2009 |
| 975 |
May 22, 2009 |
SQLAuthority News – Download – SQL Server 2008 Developer Training Kit |
| 974 |
May 21, 2009 |
SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: ) |
| 973 |
May 20, 2009 |
SQL Server – Download PDF SQL Server Cheat Sheet |
| 972 |
May 19, 2009 |
SQLAuthority News – SQL Server Energy Event – Mark Your Calendar – May 20, 2009 |
| 971 |
May 18, 2009 |
SQL SERVER – Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created |
| 970 |
May 17, 2009 |
SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table |
| 969 |
May 17, 2009 |
SQLAuthority News – Gandhinagar SQL Server User Group Meeting – International Speaker Visiting |
| 968 |
May 16, 2009 |
SQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends |
| 967 |
May 15, 2009 |
SQLAuthority News – TechEd India 2009 – Day 2 – In-Person Meeting with Industry Leaders – Community Party |
| 966 |
May 14, 2009 |
SQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People |
| 965 |
May 13, 2009 |
SQLAuthority News – TechEd India 2009 – Day 0 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Catch Me Live |
| 964 |
May 12, 2009 |
SQLAuthority News – Release of SQL Server 2008 R2 Announced |
| 963 |
May 12, 2009 |
SQL SERVER – How to Drop Primary Key Contraint |
| 962 |
May 11, 2009 |
SQL SERVER – Questions and Answers with Database Administrators |
| 961 |
May 10, 2009 |
SQL SERVER – 10 Reasons for Database Outsourcing |
| 960 |
May 09, 2009 |
SQL SERVER – Find Last Date Time Updated for Any Table |
| 959 |
May 08, 2009 |
SQLAuthority News – Future of Business Intelligence and Databases – Article by Nupur Dave |
| 958 |
May 07, 2009 |
SQL SERVER – FIX : Error : Windows Update; Error Code 8000FFFF |
| 957 |
May 06, 2009 |
SQLAuthority News – Book Review – SQL Server 2008 Management and Administration by Ross Mistry |
| 956 |
May 05, 2009 |
SQLAuthority News – Author Visit – TechEd India 2009 – Hyderabad |
| 955 |
May 04, 2009 |
SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications |
| 954 |
May 03, 2009 |
SQL SERVER – Add or Remove Identity Property on Column |
| 953 |
May 02, 2009 |
SQL SERVER – Example of DDL, DML, DCL and TCL Commands |
| 952 |
May 01, 2009 |
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009 |
| 951 |
Apr 30, 2009 |
SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1) |
| 950 |
Apr 29, 2009 |
SQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation |
| 949 |
Apr 28, 2009 |
SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script |
| 948 |
Apr 27, 2009 |
SQLAuthority News – Starting the SQL Journey – How Did I Get Started With SQL? |
| 947 |
Apr 26, 2009 |
SQL SERVER – List All the Tables for All Databases Using System Tables |
| 946 |
Apr 25, 2009 |
SQLAuthority News – Interview of Author on 60 Seconds with Pinal Dave |
| 945 |
Apr 24, 2009 |
SQL SERVER – Leading Zero to Number |
| 944 |
Apr 24, 2009 |
SQL SERVER – Introduction to SQL Server 2008 Profiler |
| 943 |
Apr 23, 2009 |
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009 |
| 942 |
Apr 23, 2009 |
SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login |
| 941 |
Apr 22, 2009 |
SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition |
| 940 |
Apr 21, 2009 |
SQL SERVER – What is Cloud Computing – Introduction to Cloud Computing |
| 939 |
Apr 20, 2009 |
SQLAuthority Book Review – Pro T-SQL 2008 Programmer’s Guide by Michael Coles |
| 938 |
Apr 19, 2009 |
SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing |
| 937 |
Apr 18, 2009 |
SQLAuthority News – Troubleshooting Performance Problems in SQL Server 2008 |
| 936 |
Apr 17, 2009 |
SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested |
| 935 |
Apr 16, 2009 |
SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD |
| 934 |
Apr 15, 2009 |
SQL SERVER – Poll Result – What is Your Favorite Database? |
| 933 |
Apr 14, 2009 |
SQL SERVER – Check if Current Login is Part of Server Role Member |
| 932 |
Apr 13, 2009 |
SQL SERVER – Introduction to JOINs – Basic of JOINs |
| 931 |
Apr 12, 2009 |
SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008) |
| 930 |
Apr 11, 2009 |
SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions |
| 929 |
Apr 10, 2009 |
SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible |
| 928 |
Apr 10, 2009 |
SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007 |
| 927 |
Apr 10, 2009 |
SQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates |
| 926 |
Apr 09, 2009 |
SQL SERVER – Fix : Error : Msg 9803, Level 16. Invalid data for type “numeric” – Data Type Mapping for Oracle Publishers |
| 925 |
Apr 08, 2009 |
SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16 |
| 924 |
Apr 08, 2009 |
SQLAuthority News – SQL Server 2008 Service Pack 1 Released – Available for Download |
| 923 |
Apr 07, 2009 |
SQL SERVER – Server Type and File Extention |
| 922 |
Apr 06, 2009 |
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution |
| 921 |
Apr 05, 2009 |
SQL SERVER – 2008 – Management Studio New Features |
| 920 |
Apr 05, 2009 |
SQL SERVER – Mirrored Backup and Restore and Split File Backup |
| 919 |
Apr 04, 2009 |
SQL SERVER – Automated Index Defragmentation Script |
| 918 |
Apr 03, 2009 |
SQLAuthority News – Launch of Gandhinagar SQL Server User Group |
| 917 |
Apr 02, 2009 |
SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP |
| 916 |
Apr 01, 2009 |
SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column |
| 915 |
Mar 31, 2009 |
SQL SERVER – 2008 – IntelliSense Does Not Work – Enable IntelliSense |
| 914 |
Mar 30, 2009 |
SQLAuthority News – Top 10 Strategic Technologies for 2009 |
| 913 |
Mar 29, 2009 |
SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database |
| 912 |
Mar 28, 2009 |
SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download |
| 911 |
Mar 27, 2009 |
SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today |
| 910 |
Mar 27, 2009 |
SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009 |
| 909 |
Mar 26, 2009 |
SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option. |
| 908 |
Mar 26, 2009 |
SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master |
| 907 |
Mar 25, 2009 |
SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009 |
| 906 |
Mar 25, 2009 |
SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009 |
| 905 |
Mar 24, 2009 |
SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution |
| 904 |
Mar 23, 2009 |
SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located |
| 903 |
Mar 22, 2009 |
SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users |
| 902 |
Mar 21, 2009 |
SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization |
| 901 |
Mar 20, 2009 |
SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words |
| 900 |
Mar 19, 2009 |
SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones |
| 899 |
Mar 18, 2009 |
SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network |
| 898 |
Mar 17, 2009 |
SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache |
| 897 |
Mar 16, 2009 |
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display |
| 896 |
Mar 15, 2009 |
SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN |
| 895 |
Mar 14, 2009 |
SQLAuthority News – Lots of SQL Server News – Tip of the Article |
| 894 |
Mar 13, 2009 |
SQL SERVER – Profiler – Adding Filters – Observation on CPU Load |
| 893 |
Mar 12, 2009 |
SQL SERVER – What is Your Favorite Database? – Poll Continuous |
| 892 |
Mar 11, 2009 |
SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison |
| 891 |
Mar 10, 2009 |
SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display |
| 890 |
Mar 09, 2009 |
SQLAuthority News – Author Visit – Complete Wrapup of Microsoft MVP Summit 2009 Trip |
| 889 |
Mar 08, 2009 |
SQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009 |
| 888 |
Mar 07, 2009 |
SQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions |
| 887 |
Mar 06, 2009 |
SQLAuthority News – Author Visit – Toronto, Canada – Insert Image in Database |
| 886 |
Mar 05, 2009 |
SQLAuthority News – MVP Summit 2009 – Day 4 – Keynote of Steve Ballmer |
| 885 |
Mar 04, 2009 |
SQLAuthority News – MVP Summit 2009 – Day 3 – Party Day and SQL Celebrity Photos |
| 884 |
Mar 03, 2009 |
SQLAuthority News – MVP Summit 2009 – Day 2 – Most Contributing MVP of Year |
| 883 |
Mar 02, 2009 |
SQLAuthority News – MVP Summit 2009 – Day 1 – Summit Welcome and Keynotes |
| 882 |
Mar 01, 2009 |
SQLAuthority News – MVP Summit 2009 – Day 0 – About Pinal Dave |
| 881 |
Feb 28, 2009 |
SQLAuthority News – MVP Summit 2009 – Database Industry Discussion – Live From London Airport and Sheraton Seattle |
| 880 |
Feb 27, 2009 |
SQLAuthority News – MVP Summit 2009 – Journey Begins |
| 879 |
Feb 26, 2009 |
SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database |
| 878 |
Feb 25, 2009 |
The Poll – What is Your Favorite Database? |
| 877 |
Feb 24, 2009 |
SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond |
| 876 |
Feb 24, 2009 |
SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account |
| 875 |
Feb 23, 2009 |
SQLAuthority News – Ahmedabad User Group Meeting February 21 2009 |
| 874 |
Feb 22, 2009 |
SQL SERVER – Download – Microsoft SQL Server 2008 Management Studio Express |
| 873 |
Feb 21, 2009 |
SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index |
| 872 |
Feb 20, 2009 |
SQLAuthority News – Ahmedabad User Group Meeting February 21 2009 |
| 871 |
Feb 19, 2009 |
SQL SERVER – Enable and Disable Index Non Clustered Indexes Using T-SQL |
| 870 |
Feb 18, 2009 |
SQLAuthority Author Visit – A True Outsourcing Giant and Technology Leader DigiCorp in Ahmedabad India |
| 869 |
Feb 17, 2009 |
SQL SERVER – Find Current Location of Data and Log File of All the Database |
| 868 |
Feb 16, 2009 |
SQL SERVER – List All Server Wide Configurations Values |
| 867 |
Feb 15, 2009 |
SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup |
| 866 |
Feb 14, 2009 |
SQL SERVER – Restore Master Database – An Easy Solution |
| 865 |
Feb 13, 2009 |
SQL SERVER – Simple Example of Reading XML File Using T-SQL |
| 864 |
Feb 12, 2009 |
SQL SERVER – Simple Example of Creating XML File Using T-SQL |
| 863 |
Feb 11, 2009 |
SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005 |
| 862 |
Feb 10, 2009 |
SQL SERVER – Start SQL Server Instance in Single User Mode |
| 861 |
Feb 09, 2009 |
SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free |
| 860 |
Feb 08, 2009 |
SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2 |
| 859 |
Feb 07, 2009 |
SQL SERVER – Introduction to Force Index Query Hints – Index Hint |
| 858 |
Feb 06, 2009 |
SQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes |
| 857 |
Feb 05, 2009 |
SQLAuthority News – Two Promotion to Help Community |
| 856 |
Feb 04, 2009 |
SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index |
| 855 |
Feb 03, 2009 |
SQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster |
| 854 |
Feb 02, 2009 |
SQL SERVER – T-SQL Script for FizzBuzz Logic |
| 853 |
Feb 01, 2009 |
SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (January 2009) |
| 852 |
Jan 31, 2009 |
SQL SERVER – FIX : ERROR : Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration |
| 851 |
Jan 30, 2009 |
SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor |
| 850 |
Jan 29, 2009 |
SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD |
| 849 |
Jan 28, 2009 |
SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader |
| 848 |
Jan 27, 2009 |
SQLAuthority News – Download Cumulative update package 3 for SQL Server 2008 |
| 847 |
Jan 27, 2009 |
SQLAuthority News – Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview |
| 846 |
Jan 26, 2009 |
SQLAuthority News – Happy 60th Republic Day to India – Database Tip |
| 845 |
Jan 25, 2009 |
SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation |
| 844 |
Jan 24, 2009 |
SQLAuthority News – Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 |
| 843 |
Jan 23, 2009 |
SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2 |
| 842 |
Jan 22, 2009 |
SQLAuthority News – Milestone of 6 Million Visits – 60 Lak Visits – Search and Job |
| 841 |
Jan 21, 2009 |
SQLAuthority News – SQLAuthority News – Ahmedabad User Group Meeting January 17 2009 – Review |
| 840 |
Jan 20, 2009 |
SQL SERVER – Rules for Optimizining Any Query – Best Practices for Query Optimization |
| 839 |
Jan 19, 2009 |
SQLAuthority News – CWE/SANS TOP 25 Most Dangerous Programming Errors |
| 838 |
Jan 18, 2009 |
SQL SERVER – Difference Between Index Scan and Index Seek |
| 837 |
Jan 17, 2009 |
SQLAuthority News – Download Microsoft SQL Server Protocol Documentation |
| 836 |
Jan 16, 2009 |
SQLAuthority News – Ahmedabad User Group Meeting January 17 2009 |
| 835 |
Jan 15, 2009 |
SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF |
| 834 |
Jan 14, 2009 |
SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation |
| 833 |
Jan 13, 2009 |
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL |
| 832 |
Jan 12, 2009 |
SQLAuthority News – Humor – Favorite Website – Funny Image |
| 831 |
Jan 11, 2009 |
SQL SERVER – Top Five Articles of Year 2008 |
| 830 |
Jan 10, 2009 |
SQLAuthority News – Security White Papers |
| 829 |
Jan 09, 2009 |
SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query |
| 828 |
Jan 08, 2009 |
SQLAuthority News – Author Visit – Mumbai, India – From January 8, 2008 to January 11, 2008 |
| 827 |
Jan 07, 2009 |
SQL SERVER – Find Currently Running Query – T-SQL |
| 826 |
Jan 06, 2009 |
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor |
| 825 |
Jan 05, 2009 |
SQL SERVER – sqlcmd vs osql – Basic Comparison |
| 824 |
Jan 04, 2009 |
SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor |
| 823 |
Jan 03, 2009 |
SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction |
| 822 |
Jan 02, 2009 |
SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL |
| 821 |
Jan 01, 2009 |
SQLAuthority News – Happy New Year – 5 SQL New Year Resolutions |
| 820 |
Dec 31, 2008 |
SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life |
| 819 |
Dec 30, 2008 |
SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers – OS Choice – Server Reboots – Performance Optimization – Backup and Restore |
| 818 |
Dec 29, 2008 |
SQL SERVER – 2008 – Certification Path Complete Download PDF |
| 817 |
Dec 28, 2008 |
SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission |
| 816 |
Dec 27, 2008 |
SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles |
| 815 |
Dec 26, 2008 |
SQL SERVER – Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa’, because it does not exist or you do not have permission |
| 814 |
Dec 25, 2008 |
SQLAuthority Author Visit – Valsad, Daman, Silvassa, Vapi – Tech Meetings |
| 813 |
Dec 25, 2008 |
SQLAuthority News – Merry Christmas – Search SQLAuthority |
| 812 |
Dec 24, 2008 |
SQL SERVER – DISABLE and ENABLE user SA |
| 811 |
Dec 23, 2008 |
SQL SERVER – 2008 – Download Copy of Developer Edition for Free Is Myth |
| 810 |
Dec 22, 2008 |
SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL |
| 809 |
Dec 21, 2008 |
SQLAuthority News – SQL Server Related Downloads from Microsoft |
| 808 |
Dec 20, 2008 |
SQL SERVER – Change Collation of Database Column – T-SQL Script |
| 807 |
Dec 19, 2008 |
SQLAuthority News – Download – SQL Server 2005 Books Online (December 2008) |
| 806 |
Dec 18, 2008 |
SQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3 |
| 805 |
Dec 17, 2008 |
SQL SERVER – Interesting Interview Questions – Revisited |
| 804 |
Dec 16, 2008 |
SQL SERVER – Find Collation of Database and Table Column Using T-SQL |
| 803 |
Dec 15, 2008 |
SQLAuthority News – Wedding Day of Author – Photographs – Mr. and Mrs. SQLAuthority |
| 802 |
Dec 14, 2008 |
SQL SERVER – Connect using Enterprise Manager to SQL Server 2005/2008 |
| 801 |
Dec 13, 2008 |
SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle |
| 800 |
Dec 12, 2008 |
SQLAuthority News – Wedding Day of Author – 800th Article of Blog |
| 799 |
Dec 11, 2008 |
SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution |
| 798 |
Dec 11, 2008 |
SQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download |
| 797 |
Dec 10, 2008 |
SQL SERVER 2008 – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications |
| 796 |
Dec 10, 2008 |
SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle |
| 795 |
Dec 09, 2008 |
SQL SERVER – Find Table Rowcount Without Using T-SQL and Without Opening Table |
| 794 |
Dec 08, 2008 |
SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007 |
| 793 |
Dec 08, 2008 |
SQLAuthority News – Author Photographs Updated |
| 792 |
Dec 07, 2008 |
SQL SERVER – Interesting Interview Questions |
| 791 |
Dec 06, 2008 |
SQLAuthority News – 10 Days After Attack on India |
| 790 |
Dec 05, 2008 |
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008 |
| 789 |
Dec 04, 2008 |
SQL SERVER – Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals / Developers |
| 788 |
Dec 03, 2008 |
SQL SERVER – Default Collation of SQL Server 2008 |
| 787 |
Dec 02, 2008 |
SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial |
| 786 |
Dec 01, 2008 |
SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications |
| 785 |
Nov 30, 2008 |
SQL SERVER – Interesting Observation – Use of Index and Execution Plan |
| 784 |
Nov 29, 2008 |
SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008 |
| 783 |
Nov 28, 2008 |
SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut |
| 782 |
Nov 27, 2008 |
SQLAuthority News – Download Tools and Documentation for SQL SERVER |
| 781 |
Nov 26, 2008 |
SQLAuthority News – Help to Find Recession Proof Job |
| 780 |
Nov 25, 2008 |
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008 |
| 779 |
Nov 24, 2008 |
SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY |
| 778 |
Nov 23, 2008 |
SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2008 |
| 777 |
Nov 22, 2008 |
SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema |
| 776 |
Nov 21, 2008 |
SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide |
| 775 |
Nov 20, 2008 |
SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database |
| 774 |
Nov 19, 2008 |
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo |
| 773 |
Nov 18, 2008 |
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3 |
| 772 |
Nov 17, 2008 |
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 2 |
| 771 |
Nov 16, 2008 |
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1 |
| 770 |
Nov 15, 2008 |
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Link List |
| 769 |
Nov 14, 2008 |
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa |
| 768 |
Nov 13, 2008 |
SQLAuthority News – RML Utilities – Usage and Additional Help |
| 767 |
Nov 12, 2008 |
SQLAuthority News – Download RML Utilities for SQL Server |
| 766 |
Nov 11, 2008 |
SQL SERVER – Delete Backup History – Cleanup Backup History |
| 765 |
Nov 10, 2008 |
SQL SERVER – Check Database Integrity for All Databases of Server |
| 764 |
Nov 09, 2008 |
SQLAuthority News – SQL Server 2008 Book Online Updated in October 2008 |
| 763 |
Nov 08, 2008 |
SQL SERVER 2008 – Connect Visual Studio 2005 Patch Download |
| 762 |
Nov 07, 2008 |
SQL SERVER – Refresh Database Using T-SQL |
| 761 |
Nov 06, 2008 |
SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server |
| 760 |
Nov 05, 2008 |
SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio |
| 759 |
Nov 04, 2008 |
SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user |
| 758 |
Nov 03, 2008 |
SQLAuthority News – SQL Server Security Whitepapers |
| 757 |
Nov 02, 2008 |
SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection |
| 756 |
Nov 01, 2008 |
SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan |
| 755 |
Oct 31, 2008 |
SQL SERVER – DECLARE Multiple Variables in One Statement |
| 754 |
Oct 30, 2008 |
SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007 |
| 753 |
Oct 29, 2008 |
SQLAuthority News – Download SQL Server 2005 Service Pack 3 – CTP |
| 752 |
Oct 28, 2008 |
SQLAuthority News – Happy Diwali to All of You |
| 751 |
Oct 27, 2008 |
SQLAuthority News – Download Microsoft SQL Server 2008 Feature Pack, October 2008 |
| 750 |
Oct 26, 2008 |
SQLAuthority News – Definition – Outsourcing, Offshoring, Nearshoring, Offshore Outsourcing |
| 749 |
Oct 25, 2008 |
SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis |
| 748 |
Oct 24, 2008 |
SQLAuthority News – TOP Downloads – Bookmark |
| 747 |
Oct 23, 2008 |
Author Visit – MVP Open Day 2008 – Goa – November 15-17 |
| 746 |
Oct 22, 2008 |
SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations |
| 745 |
Oct 21, 2008 |
SQL SERVER – Fix : Error : Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel |
| 744 |
Oct 20, 2008 |
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept |
| 743 |
Oct 19, 2008 |
SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure |
| 742 |
Oct 18, 2008 |
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2 |
| 741 |
Oct 17, 2008 |
SQL SERVER – Get Common Records From Two Tables Without Using Join |
| 740 |
Oct 17, 2008 |
SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008 |
| 739 |
Oct 16, 2008 |
SQL SERVER – Downgrade Database to Previous Version |
| 738 |
Oct 15, 2008 |
SQL SERVER – Introduction and Example of UNION and UNION ALL |
| 737 |
Oct 14, 2008 |
SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only |
| 736 |
Oct 13, 2008 |
SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide) |
| 735 |
Oct 12, 2008 |
SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh |
| 734 |
Oct 11, 2008 |
SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008 |
| 733 |
Oct 10, 2008 |
SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds |
| 732 |
Oct 09, 2008 |
SQL SERVER – 2008 – TRIM() Function – User Defined Function |
| 731 |
Oct 08, 2008 |
SQLAuthority News – SQL Server 2008 – Microsoft Certifications for 70-432 70-433 70-450 70-452 |
| 730 |
Oct 07, 2008 |
SQL SERVER – 2008 – High Resolution Wallpaper and Screen Saver |
| 729 |
Oct 07, 2008 |
SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems |
| 728 |
Oct 06, 2008 |
SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008 |
| 727 |
Oct 05, 2008 |
SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download |
| 726 |
Oct 04, 2008 |
SQLAuthority News – Cumulative update package 1 for SQL Server 2008 |
| 725 |
Oct 03, 2008 |
SQL SERVER – 2008 – Find If Index is Being Used in Database |
| 724 |
Oct 03, 2008 |
SQLAuthority News – Download – Visual Studio Team System 2008 Database Edition GDR September CTP |
| 723 |
Oct 02, 2008 |
SQLAuthority News – Download – Microsoft SQL Server 2008 Books Online (August 2008) |
| 722 |
Oct 02, 2008 |
SQL Server – 2008 – Cheat Sheet – One Page PDF Download |
| 721 |
Oct 01, 2008 |
SQL SERVER – Example of PIVOT UNPIVOT Cross Tab Query in Different SQL Server Versions |
| 720 |
Sep 30, 2008 |
SQLAuthority News – Security Update for SQL Server 2005 Service Pack 2 |
| 719 |
Sep 29, 2008 |
SQL SERVER – Puzzle – Solution – Computed Columns Datatype Explanation |
| 718 |
Sep 28, 2008 |
SQL SERVER – Renaming SP is Not Good Idea – Renaming Stored Procedure Does Not Update sys.procedures |
| 717 |
Sep 27, 2008 |
SQL SERVER – Puzzle – Computed Columns Datatype Explanation |
| 716 |
Sep 26, 2008 |
SQL SERVER – Get Answer in Float When Dividing of Two Integer |
| 715 |
Sep 25, 2008 |
SQL SERVER – Guidelines and Coding Standards Complete List Download |
| 714 |
Sep 24, 2008 |
SQL SERVER – Guidelines and Coding Standards Part – 2 |
| 713 |
Sep 23, 2008 |
SQL SERVER – Guidelines and Coding Standards Part – 1 |
| 712 |
Sep 22, 2008 |
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – September 2008 |
| 711 |
Sep 21, 2008 |
SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported |
| 710 |
Sep 20, 2008 |
SQLAuthority Author Visit – Ahmedabad User Group Meeting September 2008 |
| 709 |
Sep 20, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers Complete List Download |
| 708 |
Sep 19, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 8 |
| 707 |
Sep 18, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 7 |
| 706 |
Sep 17, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 6 |
| 705 |
Sep 16, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 5 |
| 704 |
Sep 15, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 4 |
| 703 |
Sep 14, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 3 |
| 702 |
Sep 13, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 2 |
| 701 |
Sep 12, 2008 |
SQL SERVER – 2008 – Interview Questions and Answers – Part 1 |
| 700 |
Sep 11, 2008 |
SQLAuthority News – 700 Articles and Author Updates |
| 699 |
Sep 10, 2008 |
SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site |
| 698 |
Sep 09, 2008 |
SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name |
| 697 |
Sep 08, 2008 |
SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint |
| 696 |
Sep 07, 2008 |
SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint |
| 695 |
Sep 06, 2008 |
SQL SERVER – Find Primary Key Using SQL Server Management Studio |
| 694 |
Sep 05, 2008 |
SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search |
| 693 |
Sep 05, 2008 |
SQLAuthority News – Download SQL Server Related Products |
| 692 |
Sep 04, 2008 |
SQLAuthirty Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008 |
| 691 |
Sep 03, 2008 |
SQLAuthority Author Visit – Microsoft Student Partner Conference |
| 690 |
Sep 02, 2008 |
SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 2008 |
| 689 |
Sep 01, 2008 |
SQL SERVER – 2008 – Introduction to Filtered Index – Improve performance with Filtered Index |
| 688 |
Aug 31, 2008 |
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example |
| 687 |
Aug 30, 2008 |
SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0×60 |
| 686 |
Aug 29, 2008 |
SQL SERVER – Few Useful DateTime Functions to Find Specific Dates |
| 685 |
Aug 28, 2008 |
SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE |
| 684 |
Aug 27, 2008 |
SQLAuthority News – Download SQL Server 2008 Report Builder 2.0 RC1 |
| 683 |
Aug 27, 2008 |
SQLAuthority News – SQL Server Express 2008 Downloads |
| 682 |
Aug 26, 2008 |
SQL SERVER – How to Rename a Column Name or Table Name |
| 681 |
Aug 25, 2008 |
SQLAuthority News – Ahmedabad SQL Server User Group Meeting – August 2008 |
| 680 |
Aug 25, 2008 |
SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles |
| 679 |
Aug 24, 2008 |
SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server |
| 678 |
Aug 23, 2008 |
SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database |
| 677 |
Aug 22, 2008 |
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2 |
| 676 |
Aug 21, 2008 |
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log |
| 675 |
Aug 21, 2008 |
SQLAuthority News – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 |
| 674 |
Aug 20, 2008 |
SQLAuthority News – Find Your IP Address – What Is My IP Address |
| 673 |
Aug 19, 2008 |
SQL SERVER – Disable All the Trigger of Current Database |
| 672 |
Aug 18, 2008 |
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks |
| 671 |
Aug 17, 2008 |
SQL SERVER – 2005 – Best Practices Analyzer (August 2008) |
| 670 |
Aug 17, 2008 |
SQL SERVER – XML – Split a Delimited String – Generate a Delimited String |
| 669 |
Aug 16, 2008 |
SQLAuthority News – Tip of the Minute |
| 668 |
Aug 15, 2008 |
SQLAuthority News – Happy Indepedance Day to India |
| 667 |
Aug 15, 2008 |
SQL SERVER – 2008 – Introduction to Online Indexing Operation |
| 666 |
Aug 14, 2008 |
SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions |
| 665 |
Aug 13, 2008 |
SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website |
| 664 |
Aug 12, 2008 |
SQLAuthority News – SQL Server 2008 Pricing and Licensing |
| 663 |
Aug 12, 2008 |
SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English |
| 662 |
Aug 11, 2008 |
SQLAuthority News – SQL Server 2008 Downloads Availables |
| 661 |
Aug 10, 2008 |
SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2005 – Detail Tutorial |
| 660 |
Aug 09, 2008 |
SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server |
| 659 |
Aug 08, 2008 |
SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 |
| 658 |
Aug 08, 2008 |
SQL SERVER – 2008 – Released To Manufacturing Available |
| 657 |
Aug 07, 2008 |
SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle |
| 656 |
Aug 06, 2008 |
SQL SERVER – Query to Find Column From All Tables of Database |
| 655 |
Aug 05, 2008 |
SQL SERVER – 2005 – Get Field Name and Type of Database Table |
| 654 |
Aug 04, 2008 |
SQLAuthority News – SQLAuthority Site With New Banner |
| 653 |
Aug 03, 2008 |
SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN |
| 652 |
Aug 02, 2008 |
SQL SERVER – Effect of Order of Join In Query |
| 651 |
Aug 01, 2008 |
SQL SERVER – 2008 – Get Current System Date Time |
| 650 |
Jul 31, 2008 |
SQL SERVER – 2008 – Find Current System Date Time and Time Offset |
| 649 |
Jul 30, 2008 |
SQLAuthority News – Author BirthDay – SQL Server Birthday |
| 648 |
Jul 29, 2008 |
SQL SERVER – SQL SERVER – Simple Example of Recursive CTE – Part 2 – MAXRECURSION – Prevent CTE Infinite Loop |
| 647 |
Jul 28, 2008 |
SQL SERVER – Simple Example of Recursive CTE |
| 646 |
Jul 27, 2008 |
SQL SERVER – mssqlsystemresource – Resource Database |
| 645 |
Jul 26, 2008 |
SQLAuthority News – Readers Selection – Readers Most Favorite Articles |
| 644 |
Jul 25, 2008 |
SQLAuthority News – SQLAuthority T-Shirts, Mug, Hat and Other Product |
| 643 |
Jul 25, 2008 |
SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run |
| 642 |
Jul 24, 2008 |
SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL |
| 641 |
Jul 23, 2008 |
SQL SERVER – Introduction to Log Viewer |
| 640 |
Jul 22, 2008 |
SQL SERVER – Clear SQL Server Memory Caches |
| 639 |
Jul 21, 2008 |
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. |
| 638 |
Jul 21, 2008 |
SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008 |
| 637 |
Jul 20, 2008 |
SQL SERVER – Change the Port of Service Broker Configuration |
| 636 |
Jul 19, 2008 |
SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process. |
| 635 |
Jul 18, 2008 |
SQL SERVER – Introduction to Service Broker |
| 634 |
Jul 18, 2008 |
SQLAuthority News – Updated My Personal Book Mark Pages |
| 633 |
Jul 17, 2008 |
SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting |
| 632 |
Jul 16, 2008 |
SQL SERVER – Readers Contribution to Site – Simple Example of Cursor |
| 631 |
Jul 15, 2008 |
SQL SERVER – Deferred Name Resolution |
| 630 |
Jul 14, 2008 |
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2 |
| 629 |
Jul 13, 2008 |
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings |
| 628 |
Jul 12, 2008 |
SQL SERVER – 2008 – User Account – sa or sysadmin |
| 627 |
Jul 11, 2008 |
SQL SERVER – 2005 – Two Important Security Update |
| 626 |
Jul 10, 2008 |
SQL SERVER – 2008 – Introduction to SPARSE Columns |
| 625 |
Jul 09, 2008 |
SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations |
| 624 |
Jul 08, 2008 |
SQL SERVER – Find Space Used For Any Particular Table |
| 623 |
Jul 07, 2008 |
SQLAuthority News – Thank You to Awarding Author SQL MVP |
| 622 |
Jul 06, 2008 |
SQL SERVER – 2008 – Introduction to Row Compression |
| 621 |
Jul 05, 2008 |
SQL SERVER – Difference Between Database Mail and SQLMail |
| 620 |
Jul 04, 2008 |
SQL SERVER – Deprecated DataType vardecimal |
| 619 |
Jul 03, 2008 |
SQL SERVER – 2008 – Introduction to New Feature of Backup Compression |
| 618 |
Jul 02, 2008 |
SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor |
| 617 |
Jul 01, 2008 |
SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP |
| 616 |
Jun 30, 2008 |
SQL SERVER – 2008 – High Availability – Hot Add Memory |
| 615 |
Jun 29, 2008 |
SQLAuthority News – Rise in SQL Injection Attacks Exploiting Unverified User Data Input |
| 614 |
Jun 28, 2008 |
SQL SERVER – 2008 – High Availability – Hot Add CPU |
| 613 |
Jun 27, 2008 |
SQL SERVER – Difference Between DBMS and RDBMS |
| 612 |
Jun 26, 2008 |
SQLAuthority News – Famous Quotes From Bill Gates – Part 2 |
| 611 |
Jun 25, 2008 |
SQLAuthority Download – SQL Server Cheatsheet |
| 610 |
Jun 24, 2008 |
SQLAuthority News – Microsoft Source Code Analyzer for SQL Injection |
| 609 |
Jun 23, 2008 |
SQLAuthority News – Release Notes for SQL Server 2008 Release Candidate 0 |
| 608 |
Jun 22, 2008 |
SQL SERVER – Create Check Constraint on Column |
| 607 |
Jun 21, 2008 |
SQLAuthority News – White Paper: Security Overview for Database Administrators |
| 606 |
Jun 20, 2008 |
SQL SERVER – Find Current Identity of Table |
| 605 |
Jun 19, 2008 |
SQLAuthority News – White Paper: SQL Server 2008 Compared to Oracle Database 11g |
| 604 |
Jun 18, 2008 |
SQLAuthority News – Famous Quotes From Bill Gates |
| 603 |
Jun 17, 2008 |
SQL SERVER – 2008 – SQL Server Start Time |
| 602 |
Jun 16, 2008 |
SQL SERVER – Introduction to SERVERPROPERTY and example |
| 601 |
Jun 15, 2008 |
SQL SERVER – 2008 – Inline Variable Assignment |
| 600 |
Jun 14, 2008 |
SQLAuthority News – 600 Article and Over 3 Million Readers |
| 599 |
Jun 13, 2008 |
SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server |
| 598 |
Jun 12, 2008 |
SQL SERVER – 2008 – Step By Step Installation Guide With Images |
| 597 |
Jun 11, 2008 |
SQL SERVER – 2008 – Four Key Pillars |
| 596 |
Jun 10, 2008 |
SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies |
| 595 |
Jun 09, 2008 |
SQLAuthority News – SQL Server 2008 Release Candidate 0 |
| 594 |
Jun 08, 2008 |
SQL SERVER – Order of Conditions in WHERE Clauses |
| 593 |
Jun 07, 2008 |
SQL SERVER – PIVOT and UNPIVOT Table Examples |
| 592 |
Jun 06, 2008 |
SQLAuthority News – Search SQLAuthority – Get Email On Every Article |
| 591 |
Jun 05, 2008 |
SQL SERVER – 2008 – Compound Assignment Operators |
| 590 |
Jun 04, 2008 |
SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column |
| 589 |
Jun 03, 2008 |
SQL SERVER – Example of DISTINCT in Aggregate Functions |
| 588 |
Jun 02, 2008 |
SQL SERVER – Order Of Column In Index |
| 587 |
Jun 01, 2008 |
SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 4 |
| 586 |
May 31, 2008 |
SQL SERVER – Create Default Constraint Over Table Column |
| 585 |
May 30, 2008 |
SQLAuthority News – 3 Million Readers and Continuing Journey |
| 584 |
May 29, 2008 |
SQL SERVER – UNPIVOT Table Example |
| 583 |
May 28, 2008 |
SQLAuthority News – Download – Windows Server 2008 w/ SQL Server 2005 |
| 582 |
May 27, 2008 |
SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 3 |
| 581 |
May 26, 2008 |
SQLAuthority News – SQL SERVER 2008 – New Logo |
| 580 |
May 25, 2008 |
SQL SERVER – T-SQL Script to Devide One Column into Two Column |
| 579 |
May 24, 2008 |
SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description |
| 578 |
May 23, 2008 |
SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2 |
| 577 |
May 22, 2008 |
SQL SERVER – PIVOT Table Example |
| 576 |
May 21, 2008 |
SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance |
| 575 |
May 20, 2008 |
SQL SERVER – 2008 – Choosing the Right Edition for Your Needs |
| 574 |
May 19, 2008 |
SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks |
| 573 |
May 18, 2008 |
SQLAuthority News – SQL SERVER Database Administrator Job Description |
| 572 |
May 17, 2008 |
SQL SERVER – Ideal TempDB FileGrowth Value |
| 571 |
May 16, 2008 |
SQL SERVER – Find Table in Every Database of SQL Server – Part 3 |
| 570 |
May 15, 2008 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake |
| 569 |
May 14, 2008 |
SQL SERVER – Orphaned MS DTC Transaction Information |
| 568 |
May 13, 2008 |
SQL SERVER – Four Basic SQL Statements – SQL Operations |
| 567 |
May 12, 2008 |
SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2 |
| 566 |
May 11, 2008 |
SQL SERVER 2005 – Microsoft Will Release SP3 Soon |
| 565 |
May 10, 2008 |
SQL SERVER – Function Property – Deterministic or Non-Deterministic |
| 564 |
May 09, 2008 |
SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server |
| 563 |
May 08, 2008 |
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2 |
| 562 |
May 07, 2008 |
SQL SERVER – Create Database Error in Windows Vista |
| 561 |
May 06, 2008 |
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication |
| 560 |
May 05, 2008 |
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 |
| 559 |
May 04, 2008 |
SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution |
| 558 |
May 03, 2008 |
SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition |
| 557 |
May 02, 2008 |
SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions |
| 556 |
May 01, 2008 |
SQLAuthority News – Write for SQLAuthority |
| 555 |
Apr 30, 2008 |
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 |
| 554 |
Apr 29, 2008 |
SQL SERVER – Find Table in Every Database of SQL Server |
| 553 |
Apr 28, 2008 |
SQL SERVER – Download FAQ Sheet – SQL Server in One Page |
| 552 |
Apr 27, 2008 |
SQL SERVER – Query Analyzer Shortcuts – Part 2 |
| 551 |
Apr 26, 2008 |
SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article |
| 550 |
Apr 25, 2008 |
SQL SERVER – Optimization Rules of Thumb – Best Practices |
| 549 |
Apr 25, 2008 |
SQLAuthority News – Authors Personal Bookmarks |
| 548 |
Apr 24, 2008 |
SQLAuthority News – Download Microsoft Office Visio 2007 Professional SQL Server Add-In |
| 547 |
Apr 23, 2008 |
SQL SERVER – Converting Subqueries to Joins |
| 546 |
Apr 22, 2008 |
SQL SERVER – Better Performance – LEFT JOIN or NOT IN? |
| 545 |
Apr 21, 2008 |
SQL SERVER – 2008 – Update Resolving Conflict Between SQL Server 2005 and SQL Server 2008 |
| 544 |
Apr 20, 2008 |
SQL SERVER – Identifiers As Valid Object Names |
| 543 |
Apr 19, 2008 |
SQL SERVER – Is Cursor Database Object or Datatype |
| 542 |
Apr 18, 2008 |
SQL SERVER – Generate Foreign Key Scripts For Database |
| 541 |
Apr 17, 2008 |
SQLAuthority News – My Favorite Link of This Blog |
| 540 |
Apr 16, 2008 |
SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures |
| 539 |
Apr 15, 2008 |
SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks |
| 538 |
Apr 14, 2008 |
SQL SERVER – SQL Slammer (Computer Worm) |
| 537 |
Apr 13, 2008 |
SQL SERVER – 2008 – Important Resources |
| 536 |
Apr 12, 2008 |
SQL SERVER – 2008 – Download Presentation and Whitepapers |
| 535 |
Apr 11, 2008 |
SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2 |
| 534 |
Apr 10, 2008 |
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2 |
| 533 |
Apr 09, 2008 |
SQL SERVER – 2005 – Connection Strings For .NET |
| 532 |
Apr 08, 2008 |
SQL SERVER – Change Order of Column In Database Tables |
| 531 |
Apr 07, 2008 |
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) |
| 530 |
Apr 06, 2008 |
SQL SERVER – 15 Best Practices for Better Database Performance |
| 529 |
Apr 05, 2008 |
SQL SERVER – 2005 – Transferring Ownership of a Schema to a User |
| 528 |
Apr 04, 2008 |
SQLAuthority News – Translation in International Languages – Arabic, Chinese, Dutch, French, German, Greek, Italian, Japanese, Korean, Portuguese, Russian, Spanish |
| 527 |
Apr 03, 2008 |
SQLAuthority News – Learn New Things – Self Criticism |
| 526 |
Apr 02, 2008 |
SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value |
| 525 |
Apr 01, 2008 |
SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download |
| 524 |
Mar 31, 2008 |
SQL SERVER – Popular Articles of SQLAuthority Blog |
| 523 |
Mar 30, 2008 |
SQL SERVER – Introduction to Heap Structure – What is Heap? |
| 522 |
Mar 29, 2008 |
SQL SERVER – 2005 – List All Column With Indentity Key In Specific Database |
| 521 |
Mar 28, 2008 |
SQL SERVER – 2005 – Introduction to sys.dm_exec_query_optimizer_info |
| 520 |
Mar 27, 2008 |
SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance |
| 519 |
Mar 26, 2008 |
SQLAuthority News – Few Links About SQLAuthority |
| 518 |
Mar 25, 2008 |
SQL SERVER – Simple Puzzle Using Union and Union All – Answer |
| 517 |
Mar 24, 2008 |
SQL SERVER – Simple Puzzle Using Union and Union All |
| 516 |
Mar 23, 2008 |
SQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning |
| 515 |
Mar 22, 2008 |
SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure |
| 514 |
Mar 21, 2008 |
SQL SERVER – Introduction to Live Lock – What is Live Lock? |
| 513 |
Mar 20, 2008 |
SQLAuthority News – Book Review – Joe Celkos SQL Puzzles and Answers, Second Edition, Second Edition |
| 512 |
Mar 19, 2008 |
SQL SERVER – Add Column With Default Column Constraint to Table |
| 511 |
Mar 18, 2008 |
SQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices |
| 510 |
Mar 17, 2008 |
SQLAuthority News – Download White Papers – Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server |
| 509 |
Mar 16, 2008 |
SQL SERVER – 2005 – Retrieve Any User Defined Object Details Using sys.objects Database |
| 508 |
Mar 15, 2008 |
SQL SERVER – 2005 – Retrieve Processes Using Specified Database |
| 507 |
Mar 14, 2008 |
SQL SERVER – 2005 – Introduction to CLR and Integration to CLR with SQL – Simple Sample Example of CLR |
| 506 |
Mar 13, 2008 |
SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2 |
| 505 |
Mar 12, 2008 |
SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER |
| 504 |
Mar 11, 2008 |
SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3 |
| 503 |
Mar 10, 2008 |
SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 |
| 502 |
Mar 09, 2008 |
SQLAuthority News – Authors Most Visited Article on Blog |
| 501 |
Mar 08, 2008 |
SQL SERVER – 2005 – Find Nth Highest Record from Database Table |
| 500 |
Mar 07, 2008 |
SQLAuthority News – 500th Post – An Interesting Journey with SQL Server |
| 499 |
Mar 06, 2008 |
SQLAuthority News – SQL Server 2005 is The Data Platform Leader |
| 498 |
Mar 05, 2008 |
SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2 |
| 497 |
Mar 04, 2008 |
SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold |
| 496 |
Mar 03, 2008 |
SQL SERVER – Sharpen Your Basic SQL Server Skills – Learn the distinctions between unique constraint and primary key constraint and the easiest way to get random rows from a table |
| 495 |
Mar 02, 2008 |
SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL |
| 494 |
Mar 01, 2008 |
SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005 |
| 493 |
Feb 29, 2008 |
SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial |
| 492 |
Feb 28, 2008 |
SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword |
| 491 |
Feb 27, 2008 |
SQLAuthority New – Microsoft SQL Server 2008 and System Center – Managing, Deploying, and Protecting SQL Server 2008 |
| 490 |
Feb 26, 2008 |
SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation |
| 489 |
Feb 25, 2008 |
SQLAuthority News – Download Upgrade Service Datasheet |
| 488 |
Feb 24, 2008 |
SQL SERVER – 2005 – Licensing Model Compared to Other Database Products |
| 487 |
Feb 23, 2008 |
SQL SERVER – 2005 – Understanding Licensing Model |
| 486 |
Feb 22, 2008 |
SQL SERVER – Find All The User Defined Functions (UDF) – Part 2 |
| 485 |
Feb 21, 2008 |
SQLAuthority News – Download SQL Server 2008 February CTP Sample Codes |
| 484 |
Feb 21, 2008 |
SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008) |
| 483 |
Feb 20, 2008 |
SQL SERVER – UDF to Return a Calendar for Any Date for Any Year |
| 482 |
Feb 19, 2008 |
SQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command” |
| 481 |
Feb 18, 2008 |
SQLAuthority News – Download SQL Server 2008 February CTP (CTP 6) |
| 480 |
Feb 17, 2008 |
SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string ‘ |
| 479 |
Feb 16, 2008 |
SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’. |
| 478 |
Feb 15, 2008 |
SQL SERVER – Index Reorganize or Index Rebuild |
| 477 |
Feb 14, 2008 |
SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon |
| 476 |
Feb 13, 2008 |
SQL SERVER – Introduction to Three Important Performance Counters |
| 475 |
Feb 12, 2008 |
SQL SERVER – Get Current Database Name |
| 474 |
Feb 11, 2008 |
SQL SERVER – 2005 – Find Unused Indexes of Current Database |
| 473 |
Feb 10, 2008 |
SQLAuthority News – RIP: Ken Henderson, 1967 – 2008 |
| 472 |
Feb 09, 2008 |
SQLAuthority News – 2008 – Download – SQL Server 2008 Brochure |
| 471 |
Feb 08, 2008 |
SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3 |
| 470 |
Feb 07, 2008 |
SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified |
| 469 |
Feb 06, 2008 |
SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server |
| 468 |
Feb 05, 2008 |
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes |
| 467 |
Feb 04, 2008 |
SQL SERVER – Simple Example of WHILE Loop with BREAK and CONTINUE |
| 466 |
Feb 03, 2008 |
SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql) |
| 465 |
Feb 02, 2008 |
SQL SERVER – Find All The User Defined Functions (UDF) in a Database |
| 464 |
Feb 01, 2008 |
SQL SERVER – Find Great Job with Great Pay |
| 463 |
Jan 31, 2008 |
SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP |
| 462 |
Jan 30, 2008 |
SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution |
| 461 |
Jan 29, 2008 |
SQLAuthority New – O’relly Style Book Cover for SQLAuthority |
| 460 |
Jan 28, 2008 |
SQLAuthority News – Book Review – Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 |
| 459 |
Jan 27, 2008 |
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes |
| 458 |
Jan 26, 2008 |
SQLAuthority News – Microsoft SQL Server 2000 MSIT Configuration Pack for Configuration Manager 2007 |
| 457 |
Jan 25, 2008 |
SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table |
| 456 |
Jan 24, 2008 |
SQL SERVER – 2005 – Introduction to Partitioning |
| 455 |
Jan 23, 2008 |
SQLAuthority News – Download Microsoft SQL Server 2005 Assessment Configuration Pack |
| 454 |
Jan 22, 2008 |
SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working |
| 453 |
Jan 21, 2008 |
SQL SERVER – 2005 – Get a row per file of a database as stored in the master database |
| 452 |
Jan 20, 2008 |
SQL SERVER – Introduction to Statistical Functions – VAR, STDEVP, STDEV, VARP |
| 451 |
Jan 19, 2008 |
SQL SERVER – Introduction to Aggregate Functions |
| 450 |
Jan 18, 2008 |
SQL SERVER – 2005 Best Practices Analyzer (January 2008) |
| 449 |
Jan 17, 2008 |
SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer |
| 448 |
Jan 16, 2008 |
SQLAuthroity News – Microsoft SQL Server 2000 Assessment Configuration Pack |
| 447 |
Jan 15, 2008 |
SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples |
| 446 |
Jan 14, 2008 |
SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet |
| 445 |
Jan 13, 2008 |
SQLAuthority News – Find Job Related to SQL Server and Database Administrator and Interview Questions and Answers |
| 444 |
Jan 12, 2008 |
SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure |
| 443 |
Jan 11, 2008 |
SQL SERVER – Reclaim Space After Dropping Variable-Length Columns Using DBCC CLEANTABLE |
| 442 |
Jan 10, 2008 |
SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table |
| 441 |
Jan 09, 2008 |
SQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO |
| 440 |
Jan 08, 2008 |
SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet |
| 439 |
Jan 07, 2008 |
SQL SERVER – 2005 – Introduction and Explanation to SYNONYM – Helpful T-SQL Feature for Developer |
| 438 |
Jan 06, 2008 |
SQL SERVER – Download Frequently Asked Generic Interview Questions |
| 437 |
Jan 05, 2008 |
SQL SERVER – Most Frequently Asked Generic Interview Questions |
| 436 |
Jan 04, 2008 |
SQL SERVER – 2005 – CROSS APPLY |
| 435 |
Jan 03, 2008 |
SQL SERVER – 2005 – Last Ran Query – Recently Ran Query |
| 434 |
Jan 03, 2008 |
SQLAuthority New – Best Practices for Speeding Up Your Web Site |
| 433 |
Jan 02, 2008 |
SQL SERVER – Fix : Error : 15281 SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration for this server |
| 432 |
Jan 01, 2008 |
SQLAuthority New – Happy New Year 2008 |
| 431 |
Dec 31, 2007 |
SQLAuthority News – Thank You to Blog Readers |
| 430 |
Dec 30, 2007 |
SQL SERVER – Remove Duplicate Characters From a String |
| 429 |
Dec 29, 2007 |
SQL SERVER – Change Password of SA Login Using Management Studio |
| 428 |
Dec 28, 2007 |
SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC |
| 427 |
Dec 27, 2007 |
SQLAuthority News – Book Review – A Practitioner’s Guide to Software Test Design |
| 426 |
Dec 26, 2007 |
SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed |
| 425 |
Dec 25, 2007 |
SQL SERVER – Mirrored Backup Introduction and Explanation |
| 424 |
Dec 25, 2007 |
SQL SERVER – Delete Duplicate Records – Count Duplicate Records Links |
| 423 |
Dec 24, 2007 |
SQL SERVER – Object Oriented Database Management Systems |
| 422 |
Dec 24, 2007 |
SQLAuthority News – Download Microsoft SQL Server 2000/2005 Management Pack |
| 421 |
Dec 24, 2007 |
SQLAuthority News – Jobs, Search, Best Articles, Homepage |
| 420 |
Dec 23, 2007 |
SQL SERVER – 2008 – New DataTypes DATE and TIME |
| 419 |
Dec 22, 2007 |
SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script |
| 418 |
Dec 21, 2007 |
SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact |
| 417 |
Dec 20, 2007 |
SQL SERVER – DISTINCT Keyword Usage and Common Discussion |
| 416 |
Dec 19, 2007 |
SQL SERVER – Cumulative Update Package 5 for SQL Server 2005 Service Pack 2 |
| 415 |
Dec 19, 2007 |
SQLAuthority News – RML Utilities for SQL Server |
| 414 |
Dec 18, 2007 |
SQL SERVER – Get Information of Index of Tables and Indexed Columns |
| 413 |
Dec 17, 2007 |
SQL SERVER – T-SQL Script to Find Details About TempDB |
| 412 |
Dec 16, 2007 |
SQL SERVER – Solution – Log File Very Large – Log Full |
| 411 |
Dec 15, 2007 |
SQL SERVER – TempDB Restrictions – Temp Database Restrictions |
| 410 |
Dec 14, 2007 |
SQLAuthority News – Top 10 Tips for Successful Software Outsourcing |
| 409 |
Dec 13, 2007 |
SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL) |
| 408 |
Dec 12, 2007 |
SQL SERVER – White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server |
| 407 |
Dec 11, 2007 |
SQL SERVER – Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Refresh |
| 406 |
Dec 10, 2007 |
SQLAuthority News – Microsoft SQL Server 2008 Community Technology Preview (November 2007) VHD |
| 405 |
Dec 09, 2007 |
SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability) |
| 404 |
Dec 08, 2007 |
SQL SERVER – Generic Architecture Image |
| 403 |
Dec 07, 2007 |
SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use. |
| 402 |
Dec 06, 2007 |
SQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) |
| 401 |
Dec 05, 2007 |
SQL SERVER – UDF – Remove Duplicate Chars From String |
| 400 |
Dec 04, 2007 |
SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource |
| 399 |
Dec 03, 2007 |
SQL SERVER – Grouping JOIN Clauses In SQL |
| 398 |
Dec 02, 2007 |
SQL SERVER – Q and A with Database Administrators |
| 397 |
Dec 01, 2007 |
SQL SERVER – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator |
| 396 |
Nov 30, 2007 |
SQLAuthority News – Download SQL Server 2005 Books Online (September 2007) |
| 395 |
Nov 29, 2007 |
SQL SERVER – Database Interview Questions and Answers Complete List |
| 394 |
Nov 28, 2007 |
SQL SERVER – Correct Syntax for Stored Procedure SP |
| 393 |
Nov 27, 2007 |
SQL SERVER – 2005 – List All Stored Procedure in Database |
| 392 |
Nov 26, 2007 |
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF |
| 391 |
Nov 25, 2007 |
SQLAuthority News – SQL Server Compact 3.5 Downloads and ReportViewer Visual Studio Download |
| 390 |
Nov 24, 2007 |
SQL SERVER – Upgrade Advise – From 2000 to 2005 or 2008 |
| 389 |
Nov 23, 2007 |
SQL SERVER – 2008 – November CPT5 New Improvement |
| 388 |
Nov 22, 2007 |
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2 |
| 387 |
Nov 21, 2007 |
SQL SERVER – Generate Incremented Linear Number Sequence |
| 386 |
Nov 20, 2007 |
SQL SERVER – Sharpen Your Skills: Joins, Groupings, and Data Types |
| 385 |
Nov 19, 2007 |
SQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available |
| 384 |
Nov 18, 2007 |
SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide – SQL Server, ColdFusion, ASP.NET |
| 383 |
Nov 17, 2007 |
SQL SERVER – 2005 – Best Practices for SQL Server Health Check |
| 382 |
Nov 16, 2007 |
SQL SERVER – 2005 – Generate Script with Data from Database – Database Publishing Wizard |
| 381 |
Nov 15, 2007 |
SQLAuthority News – Microsoft SQL Server 2005 Assessment Configuration Pack Download |
| 380 |
Nov 14, 2007 |
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Database Dilbert |
| 379 |
Nov 14, 2007 |
SQLAuthority News – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007 |
| 378 |
Nov 13, 2007 |
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution |
| 377 |
Nov 12, 2007 |
SQL SERVER – FIX : ERROR Msg 1803 The CREATE DATABASE statement failed. The primary file must be at least 2 MB to accommodate a copy of the model database |
| 376 |
Nov 12, 2007 |
SQLAuthority News – The Equations of Relativist |
| 375 |
Nov 12, 2007 |
SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB |
| 374 |
Nov 11, 2007 |
SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool |
| 373 |
Nov 10, 2007 |
SQL SERVER – 2005 2000 – Search String in Stored Procedure |
| 372 |
Nov 09, 2007 |
SQL SERVER – Versions, CodeNames, Year of Release |
| 371 |
Nov 08, 2007 |
SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback) |
| 370 |
Nov 07, 2007 |
SQLAuthority News – 1 Million Visitors in last 1 year |
| 369 |
Nov 06, 2007 |
SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1 |
| 368 |
Nov 05, 2007 |
SQLAuthority News – Few Add-ons for SQLAuthority |
| 367 |
Nov 04, 2007 |
SQLAuthority News – Best Articles on SQLAuthority.com |
| 366 |
Nov 03, 2007 |
SQLAuthority News – Best SQLAuthority Articles on Other Popular Sites |
| 365 |
Nov 02, 2007 |
SQLAuthority News – Best Downloads on SQLAuthority.com |
| 364 |
Nov 01, 2007 |
SQLAuthority News – First Birthday of Blog – 365 Post in One Year |
| 363 |
Oct 31, 2007 |
SQL SERVER – Importance of Master Database for SQL Server Startup |
| 362 |
Oct 30, 2007 |
SQL SERVER – Business Intelligence (BI) Basic Terms Explanation |
| 361 |
Oct 29, 2007 |
SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers |
| 360 |
Oct 28, 2007 |
SQL SERVER – 2008 – Server Consolidation WhitePaper Download |
| 359 |
Oct 27, 2007 |
SQL SERVER – 2005 – Get Current User – Get Logged In User |
| 358 |
Oct 26, 2007 |
SQL SERVER – Deterministic Functions and Nondeterministic Functions |
| 357 |
Oct 25, 2007 |
SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS |
| 356 |
Oct 24, 2007 |
SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords |
| 355 |
Oct 23, 2007 |
SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database |
| 354 |
Oct 22, 2007 |
SQL SERVER – Difference Between @@Version and xp_msver – Retrieve SQL Server Information |
| 353 |
Oct 21, 2007 |
SQL SERVER – 2005 – Limitation of Online Index Rebuld Operation |
| 352 |
Oct 20, 2007 |
SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script |
| 351 |
Oct 19, 2007 |
SQL SERVER – Types of DBCC Commands When Used as Database Console Commands |
| 350 |
Oct 18, 2007 |
SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC |
| 349 |
Oct 17, 2007 |
SQLAuthority News – Book Review – Backup & Recovery (Paperback) |
| 348 |
Oct 16, 2007 |
SQL SERVER – Three T-SQL Script to Create Primary Keys on Table |
| 347 |
Oct 16, 2007 |
SQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007) |
| 346 |
Oct 15, 2007 |
SQL SERVER – Explanation and Understanding NOT NULL Constraint |
| 345 |
Oct 14, 2007 |
SQL SERVER – Three Rules to Use UNION |
| 344 |
Oct 13, 2007 |
SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation |
| 343 |
Oct 12, 2007 |
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards |
| 342 |
Oct 11, 2007 |
SQL SERVER – T-SQL Script to Add Clustered Primary Key |
| 341 |
Oct 10, 2007 |
SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE |
| 340 |
Oct 09, 2007 |
SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE |
| 339 |
Oct 08, 2007 |
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS |
| 338 |
Oct 07, 2007 |
SQLAuthority News – Latest Interesting Downloads and Articles |
| 337 |
Oct 06, 2007 |
SQL SERVER – Executing Remote Stored Procedure – Calling Stored Procedure on Linked Server |
| 336 |
Oct 05, 2007 |
SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example |
| 335 |
Oct 04, 2007 |
SQL SERVER – 2005 – Different Types of Cache Objects |
| 334 |
Oct 03, 2007 |
SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling With RAISEERROR Function |
| 333 |
Oct 02, 2007 |
SQL SERVER – Find Name of The SQL Server Instance |
| 332 |
Oct 01, 2007 |
SQL SERVER – 2005 – OUTPUT Clause Example and Explanation with INSERT, UPDATE, DELETE |
| 331 |
Sep 30, 2007 |
SQL SERVER – 2005 Query Editor – Microsoft SQL Server Management Studio |
| 330 |
Sep 29, 2007 |
SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS |
| 329 |
Sep 28, 2007 |
SQL SERVER – Introduction and Example for DATEFORMAT Command |
| 328 |
Sep 27, 2007 |
SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database |
| 327 |
Sep 26, 2007 |
SQLAuthority News – Book Review – Programming SQL Server 2005 [ILLUSTRATED] |
| 326 |
Sep 25, 2007 |
SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT |
| 325 |
Sep 24, 2007 |
SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used |
| 324 |
Sep 23, 2007 |
SQL SERVER – Stored Procedure to Know Database Access Permission to Current User |
| 323 |
Sep 22, 2007 |
SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver |
| 322 |
Sep 21, 2007 |
SQL SERVER – 2005 – Multiple Language Support |
| 321 |
Sep 20, 2007 |
SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full |
| 320 |
Sep 19, 2007 |
SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode |
| 319 |
Sep 18, 2007 |
SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots |
| 318 |
Sep 18, 2007 |
SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function |
| 317 |
Sep 17, 2007 |
SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management |
| 316 |
Sep 17, 2007 |
SQL SERVER – Difference Between UPDATE and UPDATE() |
| 315 |
Sep 16, 2007 |
SQLAuthority News – Active Directory Integration Sample Script |
| 314 |
Sep 16, 2007 |
SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database |
| 313 |
Sep 15, 2007 |
SQLAuthority News – Book Review – Pro T-SQL 2005 Programmer’s Guide (Paperback) |
| 312 |
Sep 14, 2007 |
SQLAuthority News – Random Article from SQLAuthority Blog |
| 311 |
Sep 13, 2007 |
SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always |
| 310 |
Sep 12, 2007 |
SQLAuthority News – Scrum: Agile Software Development for Project Management |
| 309 |
Sep 11, 2007 |
SQL SERVER – Frequency of SQL Server Reboot and Restart |
| 308 |
Sep 11, 2007 |
SQLAuthority News – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills |
| 307 |
Sep 10, 2007 |
SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005 |
| 306 |
Sep 10, 2007 |
SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide |
| 305 |
Sep 09, 2007 |
SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt |
| 304 |
Sep 08, 2007 |
SQL SERVER – UDF – User Defined Function – Get Number of Days in Month |
| 303 |
Sep 07, 2007 |
SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example |
| 302 |
Sep 06, 2007 |
SQL SERVER – 2005 – Introduction and Explanation to sqlcmd |
| 301 |
Sep 06, 2007 |
SQLAuthority News – SQL SERVER 2008 CTP 4 Released |
| 300 |
Sep 05, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Valid SQL Error |
| 299 |
Sep 05, 2007 |
SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel |
| 298 |
Sep 04, 2007 |
SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database |
| 297 |
Sep 04, 2007 |
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database |
| 296 |
Sep 03, 2007 |
SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text |
| 295 |
Sep 02, 2007 |
SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward |
| 294 |
Aug 31, 2007 |
SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX |
| 293 |
Aug 30, 2007 |
SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS |
| 292 |
Aug 29, 2007 |
SQL SERVER – Difference and Explanation among DECIMAL, FLOAT and NUMERIC |
| 291 |
Aug 28, 2007 |
SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan |
| 290 |
Aug 27, 2007 |
SQL SERVER – 2005 – Use Always Outer Join Clause instead of (*= and =*) |
| 289 |
Aug 26, 2007 |
SQL SERVER – 2005 – No Backup Support For Named Pipes |
| 288 |
Aug 25, 2007 |
SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error |
| 287 |
Aug 24, 2007 |
SQL SERVER – 2005 – T-SQL Script to Attach and Detach Database |
| 286 |
Aug 23, 2007 |
SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today |
| 285 |
Aug 22, 2007 |
SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code |
| 284 |
Aug 21, 2007 |
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects |
| 283 |
Aug 20, 2007 |
SQLAuthority News – Principles of Simplicity |
| 282 |
Aug 20, 2007 |
SQL SERVER – Find Monday of the Current Week |
| 281 |
Aug 19, 2007 |
SQLAuthority News – Book Review – Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes |
| 280 |
Aug 18, 2007 |
SQL SERVER – Find Last Day of Any Month – Current Previous Next |
| 279 |
Aug 17, 2007 |
SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop |
| 278 |
Aug 16, 2007 |
SQLAuthority News – Subscribed to SQLAuthority Emails |
| 277 |
Aug 16, 2007 |
SQL SERVER – 2008 – Book On-Line Link |
| 276 |
Aug 16, 2007 |
SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID() |
| 275 |
Aug 15, 2007 |
SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE |
| 274 |
Aug 14, 2007 |
SQLAuthority News – Book Review – Learning SQL on SQL Server 2005 (Learning) |
| 273 |
Aug 14, 2007 |
SQL SERVER – What is SQL? How to pronounce SQL? |
| 272 |
Aug 13, 2007 |
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details |
| 271 |
Aug 12, 2007 |
SQL SERVER – Fix : ERROR : Msg 1033, Level 15, State 1 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. |
| 270 |
Aug 11, 2007 |
SQL SERVER – UDF – Validate Integer Function |
| 269 |
Aug 10, 2007 |
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date |
| 268 |
Aug 09, 2007 |
SQL SERVER – 2005 – List All The Column With Specific Data Types |
| 267 |
Aug 08, 2007 |
SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property |
| 266 |
Aug 07, 2007 |
SQL SERVER – 2005 – List Tables in Database Without Primary Key |
| 265 |
Aug 06, 2007 |
SQL SERVER – Fix : Error 2596 The repair statement was not processed. The database cannot be in read-only mode |
| 264 |
Aug 05, 2007 |
SQL SERVER – Stop SQL Server Immediately Using T-SQL |
| 263 |
Aug 04, 2007 |
SQL SERVER – One Thing All DBA Must Know |
| 262 |
Aug 04, 2007 |
SQLAuthority News – Download SQL Server 2005 Samples and Sample Databases |
| 261 |
Aug 04, 2007 |
SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey |
| 260 |
Aug 03, 2007 |
SQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released |
| 259 |
Aug 03, 2007 |
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example |
| 258 |
Aug 02, 2007 |
SQLAuthority News – Book Review – SQL Server 2005 Practical Troubleshooting: The Database Engine |
| 257 |
Aug 02, 2007 |
SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details |
| 256 |
Aug 01, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Search SQL |
| 255 |
Aug 01, 2007 |
SQL SERVER – 2008 – July CTP Released |
| 254 |
Jul 31, 2007 |
SQLAuthority News – My Favorite Articles of This Blog |
| 253 |
Jul 30, 2007 |
SQLAuthority News – Birthday of SQL Authority Author |
| 252 |
Jul 29, 2007 |
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download |
| 251 |
Jul 28, 2007 |
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3 |
| 250 |
Jul 27, 2007 |
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 2 |
| 249 |
Jul 26, 2007 |
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1 |
| 248 |
Jul 25, 2007 |
SQLAuthority News – Interesting Read – Programming Concepts, Structured Thinking Language (STL) and Relationary |
| 247 |
Jul 25, 2007 |
SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction |
| 246 |
Jul 24, 2007 |
SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation |
| 245 |
Jul 23, 2007 |
SQL SERVER – UDF – Function to Get Previous And Next Work Day – Exclude Saturday and Sunday |
| 244 |
Jul 23, 2007 |
SQL SERVER – UDF – Get the Day of the Week Function |
| 243 |
Jul 22, 2007 |
SQLAuthority News – FQL – Facebook Query Language |
| 242 |
Jul 21, 2007 |
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted. |
| 241 |
Jul 20, 2007 |
SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup |
| 240 |
Jul 19, 2007 |
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files |
| 239 |
Jul 19, 2007 |
SQL SERVER – SPACE Function Example |
| 238 |
Jul 18, 2007 |
SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup |
| 237 |
Jul 17, 2007 |
SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable |
| 236 |
Jul 16, 2007 |
SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability |
| 235 |
Jul 15, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA |
| 234 |
Jul 14, 2007 |
SQL SERVER – 2005 Collation Explanation and Translation – Part 2 |
| 233 |
Jul 13, 2007 |
SQL SERVER – 2005 – Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename |
| 232 |
Jul 12, 2007 |
SQL SERVER – Validate Field For DATE datatype using function ISDATE() |
| 231 |
Jul 11, 2007 |
SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta |
| 230 |
Jul 11, 2007 |
SQL SERVER – 2005 – Features Comparison Chart |
| 229 |
Jul 11, 2007 |
SQL SERVER – 2008 – Scheduled Launch at an Event in Los Angeles on Feb. 27, 2008 |
| 228 |
Jul 11, 2007 |
SQL SERVER – Count Duplicate Records – Rows |
| 227 |
Jul 10, 2007 |
SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days |
| 226 |
Jul 09, 2007 |
SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained |
| 225 |
Jul 08, 2007 |
SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1 |
| 224 |
Jul 08, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Generic Quotes |
| 223 |
Jul 07, 2007 |
SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT |
| 222 |
Jul 06, 2007 |
SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type |
| 221 |
Jul 05, 2007 |
SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9 |
| 220 |
Jul 05, 2007 |
SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example |
| 219 |
Jul 04, 2007 |
SQL SERVER – 2005 Best Practices Analyzer (July BPA) |
| 218 |
Jul 04, 2007 |
SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause |
| 217 |
Jul 03, 2007 |
SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable |
| 216 |
Jul 02, 2007 |
SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC |
| 215 |
Jul 01, 2007 |
SQL SERVER – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions |
| 214 |
Jun 30, 2007 |
SQL SERVER – Fix : Error : Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000) |
| 213 |
Jun 29, 2007 |
SQL SERVER – Recompile All The Stored Procedure on Specific Table |
| 212 |
Jun 28, 2007 |
SQL SERVER – 2005 Improvements in TempDB |
| 211 |
Jun 27, 2007 |
SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file |
| 210 |
Jun 26, 2007 |
SQL SERVER – 2005 List All Tables of Database |
| 209 |
Jun 26, 2007 |
SQL SERVER – Explanation and Example Four Part Name |
| 208 |
Jun 25, 2007 |
SQL SERVER – Repeate String N Times Using String Function REPLICATE |
| 207 |
Jun 24, 2007 |
SQLAuthority News – Book Review – Microsoft(R) SQL Server 2005 Unleashed (Paperback) |
| 206 |
Jun 24, 2007 |
SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005 |
| 205 |
Jun 23, 2007 |
SQL SERVER – 2005 Row Overflow Data Explanation |
| 204 |
Jun 22, 2007 |
SQL SERVER – Explanation and Comparison of NULLIF and ISNULL |
| 203 |
Jun 21, 2007 |
SQLAuthority.com News – iGoogle Gadget Published |
| 202 |
Jun 21, 2007 |
SQL SERVER – Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()} |
| 201 |
Jun 20, 2007 |
SQL SERVER – Find Length of Text Field |
| 200 |
Jun 19, 2007 |
SQLAuthority.com News – Journey to SQL Authority Milestone of SQL Server |
| 199 |
Jun 18, 2007 |
SQL SERVER – Delay Function – WAITFOR clause – Delay Execution of Commands |
| 198 |
Jun 17, 2007 |
SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance |
| 197 |
Jun 16, 2007 |
SQL SERVER – 2005 – UDF – User Defined Function to Strip HTML – Parse HTML – No Regular Expression |
| 196 |
Jun 15, 2007 |
SQL SERVER – sp_HelpText for sp_HelpText – Puzzle |
| 195 |
Jun 15, 2007 |
SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 |
| 194 |
Jun 14, 2007 |
SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY |
| 193 |
Jun 14, 2007 |
SQL SERVER – Explanation SQL SERVER Hash Join |
| 192 |
Jun 13, 2007 |
SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time. |
| 191 |
Jun 13, 2007 |
SQL SERVER – Download 2005 Books Online (May 2007) |
| 190 |
Jun 13, 2007 |
SQL SERVER – Recovery Models and Selection |
| 189 |
Jun 12, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes |
| 188 |
Jun 12, 2007 |
SQL SERVER – LEN and DATALENGTH of NULL Simple Example |
| 187 |
Jun 11, 2007 |
SQL SERVER – Cannot resolve collation conflict for equal to operation |
| 186 |
Jun 11, 2007 |
SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table |
| 185 |
Jun 10, 2007 |
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice |
| 184 |
Jun 10, 2007 |
SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images. |
| 183 |
Jun 09, 2007 |
SQL SERVER – Fix : Error : Msg 9514, Level 16, State 1, Line 1 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s). |
| 182 |
Jun 09, 2007 |
SQL SERVER – Spatial Database Definition and Research Documents |
| 181 |
Jun 08, 2007 |
SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar |
| 180 |
Jun 08, 2007 |
SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL |
| 179 |
Jun 07, 2007 |
SQL SERVER – 2005 Download New Updated Book On Line (BOL) |
| 178 |
Jun 07, 2007 |
SQL SERVER – 2008 (Katmai) June CTP Released – Improvement Pillars – Diagram |
| 177 |
Jun 07, 2007 |
SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again. |
| 176 |
Jun 06, 2007 |
SQL SERVER Database Coding Standards and Guidelines Complete List Download |
| 175 |
Jun 05, 2007 |
SQL SERVER – Database Coding Standards and Guidelines – Part 2 |
| 174 |
Jun 04, 2007 |
SQL SERVER – Database Coding Standards and Guidelines – Part 1 |
| 173 |
Jun 03, 2007 |
SQL SERVER Database Coding Standards and Guidelines – Introduction |
| 172 |
Jun 03, 2007 |
SQL SERVER – 2005 Explanation and Example – SELF JOIN |
| 171 |
Jun 02, 2007 |
SQL SERVER – 2005 – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 – Download SQL Server MOM 2005 |
| 170 |
Jun 02, 2007 |
SQLAuthority News – Subscribe to Feed in Email |
| 169 |
Jun 01, 2007 |
SQLAuthority News – Dedicated Search Engine for SQLAuthority – Search SQL Solutions |
| 168 |
Jun 01, 2007 |
SQL SERVER – 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length |
| 167 |
May 31, 2007 |
SQL SERVER – Retrieve Information of SQL Server Agent Jobs |
| 166 |
May 31, 2007 |
SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio |
| 165 |
May 31, 2007 |
SQL SERVER – Primary Key Must Not Contain NULL – Primary Key are NOT NULL |
| 164 |
May 30, 2007 |
SQLAuthority.com News – Best SQL Job Search – Best SQL Job List – Find SQL Jobs |
| 163 |
May 30, 2007 |
SQL SERVER – Trace Flags – DBCC TRACEON |
| 162 |
May 30, 2007 |
SQL SERVER – Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table |
| 161 |
May 29, 2007 |
SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility |
| 160 |
May 29, 2007 |
SQL SERVER – User Defined Functions (UDF) Limitations |
| 159 |
May 28, 2007 |
SQLAuthority News – Author Visit – Meeting with Readers – Top Three Features of SQL SERVER 2005 |
| 158 |
May 28, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – SP |
| 157 |
May 27, 2007 |
SQL SERVER – Download Feature Pack for Microsoft SQL Server 2005 |
| 156 |
May 27, 2007 |
SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples |
| 155 |
May 26, 2007 |
SQL SERVER – 2005 Replace TEXT with VARCHAR(MAX) – Stop using TEXT, NTEXT, IMAGE Data Types |
| 154 |
May 26, 2007 |
SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key |
| 153 |
May 25, 2007 |
SQL SERVER – Change Default Fill Factor For Index |
| 152 |
May 25, 2007 |
SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object |
| 151 |
May 24, 2007 |
SQL SERVER – Disadvantages (Problems) of Triggers |
| 150 |
May 24, 2007 |
SQL SERVER – 2005 Retrieve Configuration of Server |
| 149 |
May 23, 2007 |
SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases |
| 148 |
May 23, 2007 |
SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator |
| 147 |
May 23, 2007 |
SQLAuthority News – New Scoble Plugin of WordPress |
| 146 |
May 22, 2007 |
SQLAuthority News – T-Shirts in Action |
| 145 |
May 22, 2007 |
SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN |
| 144 |
May 21, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – T-Shirt |
| 143 |
May 21, 2007 |
SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks |
| 142 |
May 21, 2007 |
SQL SERVER – 2005 Build List Link |
| 141 |
May 20, 2007 |
SQL SERVER – SQL Code Formatter Tools |
| 140 |
May 20, 2007 |
SQL SERVER – Script/Function to Find Last Day of Month |
| 139 |
May 19, 2007 |
SQL SERVER – ASCII to Decimal and Decimal to ASCII |
| 138 |
May 19, 2007 |
SQL SERVER – Math Functions for 2005 |
| 137 |
May 18, 2007 |
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples |
| 136 |
May 18, 2007 |
SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator |
| 135 |
May 17, 2007 |
SQLAuthority News – Limited Edition T-Shirts Arrived |
| 134 |
May 17, 2007 |
SQL SERVER – Disable Index – Enable Index – ALTER Index |
| 133 |
May 16, 2007 |
SQL SERVER – Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction |
| 132 |
May 16, 2007 |
SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery |
| 131 |
May 15, 2007 |
SQL SERVER – Binary Sequence Generator – Truth Table Generator |
| 130 |
May 15, 2007 |
SQL SERVER – DBCC commands List – documented and undocumented |
| 129 |
May 14, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Photo |
| 128 |
May 14, 2007 |
SQL SERVER – MS TechNet : Storage Top 10 Best Practices |
| 127 |
May 13, 2007 |
SQL SERVER – Query to Find First and Last Day of Current Month |
| 126 |
May 13, 2007 |
SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String |
| 125 |
May 12, 2007 |
SQL SERVER – 2005 – List all the database |
| 124 |
May 12, 2007 |
SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support |
| 123 |
May 11, 2007 |
SQL SERVER – Explanation SQL Command GO |
| 122 |
May 11, 2007 |
SQL SERVER – Download Microsoft SQL Server 2005 System Views Map |
| 121 |
May 10, 2007 |
SQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft |
| 120 |
May 10, 2007 |
SQL SERVER – Fix: Error : HResult 0×2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server |
| 119 |
May 10, 2007 |
SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time |
| 118 |
May 09, 2007 |
SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog. |
| 117 |
May 09, 2007 |
SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion |
| 116 |
May 08, 2007 |
SQL SERVER – Index Optimization CheckList |
| 115 |
May 08, 2007 |
SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas |
| 114 |
May 07, 2007 |
SQL SERVER – Top 10 Hidden Gems in SQL Server 2005 |
| 113 |
May 07, 2007 |
SQL SERVER – 2005/2000 Examples and Explanation for GOTO |
| 112 |
May 06, 2007 |
SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP |
| 111 |
May 06, 2007 |
SQL SERVER – UDF – Function to Convert List to Table |
| 110 |
May 05, 2007 |
SQL SERVER – 2005 Enable CLR using T-SQL script |
| 109 |
May 05, 2007 |
SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates |
| 108 |
May 04, 2007 |
SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName |
| 107 |
May 04, 2007 |
SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts) |
| 106 |
May 03, 2007 |
SQL SERVER – DBCC commands to free several SQL Server memory caches |
| 105 |
May 03, 2007 |
SQL SERVER – Enable Login – Disable Login using ALTER LOGIC – Change name of the ‘SA’ |
| 104 |
May 02, 2007 |
SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup |
| 103 |
May 02, 2007 |
SQL SERVER – 2005 TOP Improvements/Enhancements |
| 102 |
May 01, 2007 |
SQL SERVER – User Defined Functions (UDF) to Reverse String – UDF_ReverseString |
| 101 |
May 01, 2007 |
SQL SERVER – Copy Column Headers in Query Analyzers in Result Set |
| 100 |
May 01, 2007 |
SQLAuthority.com 100th Post – Gratitude Note to Readers |
| 99 |
Apr 30, 2007 |
SQL SERVER – Collate – Case Sensitive SQL Query Search |
| 98 |
Apr 30, 2007 |
SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query |
| 97 |
Apr 30, 2007 |
SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1 |
| 96 |
Apr 29, 2007 |
SQL SERVER – 2005 Security DataSheet |
| 95 |
Apr 29, 2007 |
SQL SERVER – Random Number Generator Script – SQL Query |
| 94 |
Apr 29, 2007 |
SQL SERVER – Replication Keywords Explanation and Basic Terms |
| 93 |
Apr 28, 2007 |
SQL SERVER – Explanation SQL SERVER Merge Join |
| 92 |
Apr 28, 2007 |
SQL SERVER – Restrictions of Views – T SQL View Limitations |
| 91 |
Apr 28, 2007 |
SQL SERVER – Good, Better and Best Programming Techniques |
| 90 |
Apr 27, 2007 |
SQL SERVER – Query to Retrieve the Nth Maximum Value |
| 89 |
Apr 27, 2007 |
SQL SERVER – 2005 Locking Hints and Examples |
| 88 |
Apr 27, 2007 |
SQL SERVER – SELECT vs. SET Performance Comparison |
| 87 |
Apr 26, 2007 |
SQL SERVER – Difference Between Unique Index vs Unique Constraint |
| 86 |
Apr 26, 2007 |
SQL SERVER – Enable xp_cmdshell using sp_configure |
| 85 |
Apr 26, 2007 |
SQL SERVER – 2005 – DBCC ROWLOCK – Deprecated |
| 84 |
Apr 25, 2007 |
SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded |
| 83 |
Apr 25, 2007 |
SQL SERVER – ERROR Messages – sysmessages error severity level |
| 82 |
Apr 25, 2007 |
SQL SERVER – 2005 Take Off Line or Detach Database |
| 81 |
Apr 24, 2007 |
SQL SERVER – TRIM() Function – UDF TRIM() |
| 80 |
Apr 24, 2007 |
SQL SERVER – Six Properties of Relational Tables |
| 79 |
Apr 24, 2007 |
SQL SERVER – 2005 Collation Explanation and Translation |
| 78 |
Apr 23, 2007 |
SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server. |
| 77 |
Apr 23, 2007 |
SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio |
| 76 |
Apr 23, 2007 |
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table |
| 75 |
Apr 23, 2007 |
SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index |
| 74 |
Apr 22, 2007 |
SQL SERVER – Raid Configuration – RAID 10 |
| 73 |
Apr 22, 2007 |
SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage |
| 72 |
Apr 22, 2007 |
SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command |
| 71 |
Apr 21, 2007 |
SQL Server Interview Questions and Answers Complete List Download |
| 70 |
Apr 20, 2007 |
SQL Server Interview Questions and Answers – Part 6 |
| 69 |
Apr 19, 2007 |
SQL Server Interview Questions and Answers – Part 5 |
| 68 |
Apr 18, 2007 |
SQL Server Interview Questions and Answers – Part 4 |
| 67 |
Apr 17, 2007 |
SQL Server Interview Questions and Answers – Part 3 |
| 66 |
Apr 16, 2007 |
SQL Server Interview Questions and Answers – Part 2 |
| 65 |
Apr 15, 2007 |
SQL Server Interview Questions and Answers – Part 1 |
| 64 |
Apr 15, 2007 |
SQL Server Interview Questions and Answers – Introduction |
| 63 |
Apr 14, 2007 |
SQL SERVER – 64 bit Architecture and White Paper |
| 62 |
Apr 14, 2007 |
SQL SERVER – CASE Statement/Expression Examples and Explanation |
| 61 |
Apr 14, 2007 |
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection. |
| 60 |
Apr 13, 2007 |
SQL SERVER – Stored Procedures Advantages and Best Advantage |
| 59 |
Apr 13, 2007 |
SQL SERVER – Script to Find SQL Server on Network |
| 58 |
Apr 13, 2007 |
SQL SERVER – 2005 – Disable Triggers – Drop Triggers |
| 57 |
Apr 12, 2007 |
SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns |
| 56 |
Apr 12, 2007 |
SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. |
| 55 |
Apr 12, 2007 |
SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System |
| 54 |
Apr 11, 2007 |
SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String |
| 53 |
Apr 11, 2007 |
SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling |
| 52 |
Apr 10, 2007 |
SQL SERVER – 2005 – Silent Installation – Unattended Installation |
| 51 |
Apr 10, 2007 |
SQL SERVER – SP Performance Improvement without changing T-SQL |
| 50 |
Apr 09, 2007 |
SQL SERVER – 2005 Reserved Keywords |
| 49 |
Apr 08, 2007 |
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX |
| 48 |
Apr 07, 2007 |
SQL SERVER – DBCC Commands Introduced in SQL Server 2005 |
| 47 |
Apr 06, 2007 |
SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1 |
| 46 |
Apr 05, 2007 |
SQL SERVER – Performance Optimization of SQL Query and FileGroups |
| 45 |
Apr 04, 2007 |
SQL SERVER – Fix: HResult 0x274D, Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired. |
| 44 |
Apr 03, 2007 |
SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005 |
| 43 |
Apr 02, 2007 |
SQL SERVER – 2005 – Performance Dashboard Reports |
| 42 |
Apr 01, 2007 |
SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive. |
| 41 |
Mar 31, 2007 |
SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP) |
| 40 |
Mar 30, 2007 |
SQL SERVER – Index Seek Vs. Index Scan (Table Scan) |
| 39 |
Mar 29, 2007 |
SQL SERVER – Difference between DISTINCT and GROUP BY – Distinct vs Group By |
| 38 |
Mar 28, 2007 |
SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON |
| 37 |
Mar 27, 2007 |
SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query |
| 36 |
Mar 25, 2007 |
SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record |
| 35 |
Mar 23, 2007 |
SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer |
| 34 |
Mar 22, 2007 |
SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. |
| 33 |
Mar 21, 2007 |
SQL SERVER – 2005 Security Best Practices – Operational and Administrative Tasks |
| 32 |
Mar 20, 2007 |
SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks |
| 31 |
Mar 16, 2007 |
SQL SERVER – Fix: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0×80004005. SQLSTATE: 08001, Native Error: 17 |
| 30 |
Mar 15, 2007 |
SQL SERVER – DBCC RESEED Table Identity Value – Reset Table Identity |
| 29 |
Mar 10, 2007 |
SQL SERVER – Union vs. Union All – Which is better for performance? |
| 28 |
Mar 07, 2007 |
SQL SERVER – Download 2005 SP2a |
| 27 |
Mar 07, 2007 |
SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running |
| 26 |
Mar 05, 2007 |
SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation |
| 25 |
Mar 01, 2007 |
SQL SERVER – Delete Duplicate Records – Rows |
| 24 |
Feb 28, 2007 |
SQL SERVER – T-SQL Script to find the CD key from Registry |
| 23 |
Feb 26, 2007 |
SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005 |
| 22 |
Feb 25, 2007 |
SQL SERVER – Restore Database Backup using SQL Script (T-SQL) |
| 21 |
Feb 24, 2007 |
SQL SERVER – Download SQL Server 2005 Books Online (February 2007) |
| 20 |
Feb 24, 2007 |
SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007) |
| 19 |
Feb 20, 2007 |
SQL SERVER – Creating Comma Separate List From Table |
| 18 |
Feb 15, 2007 |
SQL SERVER – FIX : Error 15023: User already exists in current database. |
| 17 |
Feb 10, 2007 |
SQL SERVER – Function to Convert List to Table |
| 16 |
Feb 05, 2007 |
SQL SERVER – Primary Key Constraints and Unique Key Constraints |
| 15 |
Feb 01, 2007 |
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case |
| 14 |
Jan 31, 2007 |
SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables |
| 13 |
Jan 30, 2007 |
SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure |
| 12 |
Jan 26, 2007 |
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh |
| 11 |
Jan 20, 2007 |
SQL SERVER – Query Analyzer Shortcuts |
| 10 |
Jan 10, 2007 |
SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database |
| 9 |
Jan 01, 2007 |
SQL SERVER – Simple Example of Cursor |
| 8 |
Dec 30, 2006 |
SQL SERVER – Shrinking Truncate Log File – Log Full |
| 7 |
Dec 20, 2006 |
SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved. |
| 6 |
Dec 10, 2006 |
SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure |
| 5 |
Dec 01, 2006 |
SQL SERVER – Cursor to Kill All Process in Database |
| 4 |
Nov 30, 2006 |
SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created |
| 3 |
Nov 20, 2006 |
SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database |
| 2 |
Nov 10, 2006 |
SQL SERVER – Query to Find ByteSize of All the Tables in Database |
| 1 |
Nov 01, 2006 |
SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database |
