SQL Server Code,Tips and Tricks, Performance Tuning

A blog about SQL Server, Books, Movies and life in general

Google Interview Questions | Microsoft SQL Server Books | personal blog | Ken Henderson Interview | Louis Davidson Interview | Philately and Stamp Collecting The Daily ChatGPT blog posts

Sunday, April 13, 2008

Links Of The Week 20080414

Here are the links for this week

Database

SQL Server 2005 Memory Limits and Related Questions
Microsoft to Increase Use of SQL Server 2005 Best Practices Analyzer (SQLPBA) - So Should You
SqlClient, System.Transactions, SQL Server 2008, and MARS
Visual Linq query builder for Linq to Sql
Converting an EAV design to sparse columns and populating
How It Works: SQL Server Page Allocations
How It Works: File Streams Requires Integrated Security (Windows Authentication)
Troubleshooting xp_cmdshell failures
How It Works: SQL Server Checkpoint (FlushCache) Outstanding I/O Target

Non DB tech

CSS Message Box collection
WCF: Reliable Messaging and Retry Timeouts
Google Starts to Index the Invisible Web
Download YouTube Videos as MP4 Files
New WCF Adapter Code Samples on MSDN!
IUpdatable & ADO.NET Data Services Framework
.NET Rocks! #332 - Ted Neward on the New Language Renaissance

Non tech

Why 24 hours in a Day?
The Publishing Industry Takes Another Hit
What job ads really mean
It's A Dog, Not A Towel (Pics.)
I've got your Highlander right here! [Pic]
Posted by Denis at 11:46 AM
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
Labels: Links

No comments:

Post a Comment

Newer Post Older Post Home
View mobile version
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2021 (2)
    • ►  August (1)
    • ►  March (1)
  • ►  2020 (3)
    • ►  May (2)
    • ►  January (1)
  • ►  2019 (18)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  April (3)
    • ►  March (3)
    • ►  February (5)
    • ►  January (4)
  • ►  2018 (7)
    • ►  November (1)
    • ►  September (2)
    • ►  May (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2017 (35)
    • ►  December (1)
    • ►  November (1)
    • ►  October (11)
    • ►  August (3)
    • ►  July (3)
    • ►  June (3)
    • ►  May (4)
    • ►  April (2)
    • ►  February (2)
    • ►  January (5)
  • ►  2016 (56)
    • ►  December (7)
    • ►  November (24)
    • ►  October (8)
    • ►  September (1)
    • ►  May (3)
    • ►  March (7)
    • ►  February (3)
    • ►  January (3)
  • ►  2015 (25)
    • ►  October (9)
    • ►  September (16)
  • ►  2013 (1)
    • ►  September (1)
  • ►  2012 (4)
    • ►  December (2)
    • ►  January (2)
  • ►  2011 (2)
    • ►  December (1)
    • ►  July (1)
  • ►  2010 (1)
    • ►  November (1)
  • ►  2009 (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ▼  2008 (85)
    • ►  November (1)
    • ►  October (3)
    • ►  September (1)
    • ►  August (5)
    • ►  July (5)
    • ►  June (4)
    • ►  May (14)
    • ▼  April (11)
      • SQL Teaser: Some Things Are Not What They Seem
      • How to rename a column in a SQL Server table witho...
      • Interview With Stéphane Faroult About Refactoring ...
      • Solutions for Common T-SQL Problems Wiki Launched
      • Use IDENT_CURRENT() to return the last identity va...
      • Links Of The Week 20080414
      • Video: SQL Server Data Services Architecture
      • Links Of The Week 20080405
      • Database Refactoring Interview With Scott W. Ambler
      • SQL Champ - A Quiz to Prove Your SQL Knowledge
      • Not An April Fool’s Joke: SQL Server 2000 Mainstre...
    • ►  March (11)
    • ►  February (15)
    • ►  January (15)
  • ►  2007 (253)
    • ►  December (27)
    • ►  November (21)
    • ►  October (9)
    • ►  September (6)
    • ►  August (19)
    • ►  July (25)
    • ►  June (16)
    • ►  May (21)
    • ►  April (22)
    • ►  March (38)
    • ►  February (28)
    • ►  January (21)
  • ►  2006 (252)
    • ►  December (23)
    • ►  November (23)
    • ►  October (34)
    • ►  September (23)
    • ►  August (19)
    • ►  July (18)
    • ►  June (18)
    • ►  May (22)
    • ►  April (16)
    • ►  March (20)
    • ►  February (19)
    • ►  January (17)
  • ►  2005 (54)
    • ►  December (16)
    • ►  November (14)
    • ►  October (15)
    • ►  September (9)

Popular Posts

  • After 20+ years in IT .. I finally discovered this...
    Originally I was not going to write this post, but after I found out that several other people didn't know this I figured what the heck,...
  • Can adding an index make a non SARGable query SARGable?
    This question came up the other day from a co-worker, he said he couldn't change a query but was there a way of making the same query p...
  • PostgreSQL adds FETCH FIRST WITH TIES.. just like TOP n WITH TIES in SQL Server
    PostgreSQL 13 Beta 1 was released yesterday, you can read the release notes here https://www.postgresql.org/about/news/2040/ One thing t...
  • A little less hate for: String or binary data would be truncated in table
    The error String or binary data would be truncated is one of the more annoying things in SQL Server. You would insert some data and you wou...
  • Some numbers that you will know by heart if you have been working with SQL Server for a while
    This is just a quick and fun post. I was troubleshooting a deadlock the other day and it got me thinking.... I know the number 1205 by h...
  • Five Ways To Return Values From Stored Procedures
    I have answered a bunch of questions over the last couple of days and some of them had to do with returning values from stored procedures Ev...
  • Your lack of constraints is disturbing
    It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
  • Ten SQL Server Functions That You Hardly Use But Should
    Below are 10 SQL Server functions that are hardly used but should be used a lot more I will go in more detail later on but here is a list of...
  • Convert Millisecond To "hh:mm:ss" Format
    This question was posted in the Transact-SQL MSDN Forum You have a column in your table that stores duration in milliseconds You would like ...
  • Use T-SQL to create caveman graphs
    I found this technique on Rich Benner's SQL Server Blog:  Visualising the Marvel Cinematic Universe in T-SQL  and decided to play arou...

Labels

SQL Server 2005 (79) SQL Server 2008 (61) SQL Server 2000 (40) tip (29) SQL Server (26) Best Practices (23) Howto (21) Teaser (21) SQL Server 2016 (20) Funny (18) Book (16) Gotcha (15) Interview (15) trick (15) Goofing Around (12) sad but true (12) CTP (11) Service Pack (11) Tools (11) Links (10) SQL Functions (10) Linux (9) SQL Server vNext (9) SQLPASS (9) Tips and Tricks (9) unit testing (9) tSQLt (8) LINQ (7) Nulls (7) Performance (7) Podcast (7) SQLPass2016 (7) T-SQL (7) Video (7) Visual Studio 2008 (7) unit tests (7) ASP.NET (6) Dates (6) Extreme Programming (6) Google (6) Humor (6) Indexes (6) Katmai (6) Learning (6) Performance Tuning (6) SSIS (6) Security (6) non-technical (6) sql server 2017 (6) weekend reading (6) Blog (5) Indexing (5) OLAP (5) SSMS (5) Whitepaper (5) rant (5) Agile (4) Ajax (4) Celko (4) Code (4) Dynamic Management View (4) Errors (4) Functions (4) SQL Server on Linux (4) Scrum (4) SharePoint (4) sql server 2012 (4) sqlsummit (4) what is new in SQL Server 2016 (4) Books On Line (3) Business Intelligence (3) DMV (3) Data Dude (3) Data Warehouse (3) Datetime (3) Feature Pack (3) Hacks (3) Integration Services (3) MIX07 (3) Movie (3) MySQL (3) Oracle (3) Orcas (3) Python (3) Reporting Services (3) Review (3) SQL (3) SharePoint Server (3) Soccer (3) System Functions (3) TRUNCATE (3) Visual Studio (3) Wiki (3) XLINQ (3) career (3) constraints (3) github (3) pass summit (3) sql server 2014 (3) sql server 2019 (3) stored procedures (3) twitter (3) ubuntu (3) videos (3) .NET (2) .NET 3.5 (2) Administration (2) Analysis Services (2) BackToBasics (2) Better Developer (2) Bug (2) Bulk Copy (2) Christmas (2) Cool Stuff (2) Croatia (2) DELETE (2) DLINQ (2) Data (2) Denali (2) Django (2) Encryption (2) England (2) Euro 2008 (2) Excel (2) Forum (2) FoxPro (2) Hotfix (2) Identity Theft (2) Internals (2) Math (2) Microsoft Office (2) NULLIF (2) News (2) PostgreSQL (2) Puzzles (2) Ruby (2) Ruby on Rails (2) SQL Series (2) SQL Server 2005 Analysis Services (2) SQL Server 2005 Express (2) SQLPass2014 (2) Samples (2) Screen Cast (2) Silverlight (2) Sopranos (2) Spam (2) TIL (2) To Read (2) Top Ten (2) Trigger (2) Triggers (2) Vista (2) Visual Studio 2005 (2) Visual Studio Orcas (2) Webcast (2) Windows Server 2008 (2) XAML (2) Xmas (2) bcp (2) books (2) bugs (2) bulk insert (2) database (2) files (2) flickr (2) foreign keys (2) pitfalls (2) powershell (2) query plan (2) r (2) ranking (2) scripts (2) seattle (2) temp tables (2) tsql2sday (2) views (2) windowing functions (2) Access (1) Alexa (1) Amazon (1) Amoxicillin (1) Announcement (1) Astoria (1) Azure SQL DB (1) Backup (1) Badnja Vecer (1) Beta (1) BizTalk (1) C# (1) COALESCE (1) CSLA.NET (1) CSS (1) Cadeaux (1) Change Data Capture (1) Clerks II (1) CodePlex (1) Collations (1) Computing in The Cloud (1) Crazy Stuff (1) Critical (1) DBCC (1) DDL (1) Dimensional Modeling (1) Dinner (1) Documentation (1) Dow jones (1) Download (1) Duke Nukem (1) Duke Nukem Forever (1) Entourage (1) Excel 2007 (1) FUD (1) Family (1) Federated Databases (1) Fifa (1) Food (1) Framework (1) Framwork (1) GNET (1) Game (1) Hardware (1) High Availability (1) Horror (1) IE8 (1) IIS (1) IO (1) In the cloud computing (1) Internet Explorer 8 (1) Jasper (1) Java (1) Job (1) Joe Celko (1) Kids (1) LINQ to SQL (1) LINQPad (1) Lambda Expressions (1) Lord of the Rings (1) MIX08 (1) MSDN (1) MVP (1) Malware (1) Map (1) Memory Optimized (1) Merge (1) Microsoft (1) Microsoft .NET (1) Microsoft Office PerformancePoint Server 2007 (1) NEWID() (1) NEWSEQUENTIALID() (1) NYC (1) News Corp (1) Newsgroups (1) Notification Services (1) OSS (1) OUTPUT (1) Obscure Stuff (1) Office (1) Opera (1) Operators (1) Outlook (1) Oxycodone (1) Oxycontin (1) PHP (1) Parenting (1) Partitioned Views (1) Patch (1) Pics (1) Poster (1) PowerPoint (1) Pownce. (1) Presents (1) Programming (1) Questions (1) Recovery Models (1) Red Gate (1) Refactoring (1) Root Canal (1) Roxicodone (1) SCHEMABINDING (1) SEO (1) SQL Controversy (1) SQL Injection (1) SQL Myth (1) SQL Server 2007 (1) SQL Server Data Services (1) SQL Server Data Services Architecture (1) SQL Server Integration Services (1) SQL Server Reporting Services (1) SSAS (1) SSDS (1) Sample Code (1) Samples. Code (1) Schemas (1) Search (1) Service Broker (1) Services (1) Showtime (1) Snowflake Schema (1) Software (1) Source Control (1) Spring (1) Star Schema (1) Star Wars (1) StrataFrame (1) Subversion (1) TV (1) Table valued parameters (1) Teaser.NULL (1) Tech·Ed 2007 (1) TempDB (1) Test (1) Time (1) Tortoise (1) Trace (1) Transactions (1) Tuning (1) UPSERT (1) Uefa (1) Update (1) Version Control (1) Virtual PC (1) Visual Studio Team Edition (1) WPF (1) WTF (1) Web Standards (1) Webchat (1) Windows Server (1) WorldCup 2010 (1) XP (1) analysis (1) analytical functions (1) april fools (1) art (1) blogging (1) blunders (1) book review (1) case (1) cloud (1) clustered index (1) code library (1) commodore (1) compression (1) conference (1) connect (1) connections (1) csv (1) cte (1) cursors (1) data modeling (1) data science (1) data types (1) database design (1) dos (1) extended events (1) failure (1) features (1) flickrvision (1) formats (1) formatting (1) graph (1) hekaton (1) iPhone (1) improvement (1) introductory (1) joins (1) left join (1) lessons (1) maintenance (1) manhattan (1) max (1) memoryYou can (1) metrics (1) mistakes (1) music (1) new york city (1) nosql (1) numbers (1) open data (1) phishing (1) prime numbers (1) queries (1) rdbms (1) right join (1) rss (1) sample databases (1) scripting (1) sessions (1) silly (1) sports (1) sql graph (1) sqlserver 2008 (1) static code analysis (1) tech (1) temporal data (1) twittervision (1) uniqueidentifier (1) utilities (1) variables (1) webcasts (1)
I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside..
DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you"
Awesome Inc. theme. Powered by Blogger.