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

Friday, July 15, 2011

6 new SQL Server Denali CTP3 posts

I have created 6 new SQL Server Denali CTP3 posts

These posts are about the new things introduced in SQL Server Denali CTP3, below is a list of the posts



A Quick look at the new IIF function in Denali CTP3

A Quick look at the new EOMONTH function in SQL Server Denali CTP3

DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3

ColumnStore Index limitations in SQL Server Denali CTP3

Concat function in SQL Server Denali CTP3

Format function in SQL Server Denali CTP3
Posted by Denis at 1:01 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: CTP, Denali, SQL Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2025 (1)
    • ►  May (1)
  • ►  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)
      • 6 new SQL Server Denali CTP3 posts
  • ►  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)
    • ►  March (11)
    • ►  February (15)
    • ►  January (15)
  • ►  2007 (255)
    • ►  December (27)
    • ►  November (21)
    • ►  October (9)
    • ►  September (6)
    • ►  August (19)
    • ►  July (26)
    • ►  June (16)
    • ►  May (21)
    • ►  April (22)
    • ►  March (38)
    • ►  February (29)
    • ►  January (21)
  • ►  2006 (253)
    • ►  December (23)
    • ►  November (24)
    • ►  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

Labels

SQL Server 2005 (80) SQL Server 2008 (61) SQL Server 2000 (40) tip (29) SQL Server (27) Best Practices (24) Howto (21) Teaser (21) SQL Server 2016 (20) Funny (18) Book (17) Interview (16) Gotcha (15) trick (15) Goofing Around (12) sad but true (12) CTP (11) Service Pack (11) Tools (11) Links (10) SQL Functions (10) Linux (9) Podcast (9) SQL Server vNext (9) SQLPASS (9) Tips and Tricks (9) unit testing (9) tSQLt (8) LINQ (7) Nulls (7) Performance (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) Celko (5) Indexing (5) OLAP (5) SSMS (5) Whitepaper (5) rant (5) Agile (4) Ajax (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.