Error!
Success!

By tag: 2008

showing:  of
0
kicks

How to get sql server 2008 intellisense working for schema changes  (Unpublished)

The new feature "intellisense" added in sql server 2008 is making my life easier. And I am enjoying this feature a lot. But I noticed many times that when we make any changes to DB schema like creating / modifying database objects we don't notice the schema changes in intellisense in the s...


Kicked By:
Drop Kicked By:
0
kicks

Download Sql Server 2008 R2 November CTP  (Unpublished)

Get the latest version of Sql Server 2008 version R2 [CTP]


Kicked By:
Drop Kicked By:
0
kicks

SQL Server - How to get the whole group of duplicate rows  (Unpublished)

A fast way how to get the whole duplicated group of rows in Sql Server 2005 and up.


Kicked By:
Drop Kicked By:
0
kicks

The 24 hours of PASS - SQL Server live webcasts  (Unpublished)

This years biggest online SQL Server related event. It will last full 24 hours. Don't miss it!


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2005 – Fast Running Totals solution with ordered CTE update  (Unpublished)

The Running Totals problem is as old as accounting. This is the fastest Running Totals solution using ordered Common Table Expressions (CTE) direct update feature in SQL Server 2005 and up.


Kicked By:
Drop Kicked By:
0
kicks

How to check when was SQL Server installed with a T-SQL query  (Unpublished)

Sometimes you might want to check when was SQL Server installed witha query. this is how you do it.


Kicked By:
Drop Kicked By:
0
kicks

Visual Studio 2008 var Keyword Bug - Microsoft Follow-up  (Unpublished)

Received a follow-up from Microsoft regarding <a href="http://lakario.blogspot.com/2009/07/visual-studio-2008-var-keyword-bug.html">Visual Studio var Keyword Bug</a>. Here's what Microsoft support had to say about the issue.


Kicked By:
Drop Kicked By:
0
kicks

SQL Server 2008 Extended Events - high performance eventing system  (Unpublished)

Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events.


Kicked By:
Drop Kicked By:
0
kicks

SQL Server - Find missing and unused indexes  (Unpublished)

How to find SQL Server indexes that should exists and those that shouldn't when performing index maintenance.


Kicked By:
Drop Kicked By:
0
kicks

Keyvan Nayyeri's Best Blog Posts in 2008  (Unpublished)

Like many other guys in the .NET community, Keyvan has wrote a post and listed his best of 2008 blog posts along with a short description for each post.


Kicked By:
Drop Kicked By:
0
kicks

SSMS 2008 suggests missing indexes with actual execution plan  (Unpublished)

When you choose to Include the Actual Execution Plan in SSMS 2008 it suggest any missing indexes it thinks that are needed. Plus it also calculates the performance benefit from adding them. Pretty awsome!


Kicked By:
Drop Kicked By:
0
kicks

Advanced SQL Server 2005 Express Job Scheduling  (Unpublished)

How to make run once, daily, weekly, monthly absolute and relative scheduling in SQL Server Express 2005 and 2008 without any 3rd party tools.


Kicked By:
Drop Kicked By:
0
kicks

jQuery Intellisense in VS 2008 - ScottGu's Blog  (Unpublished)

Last month I blogged about how Microsoft is extending support for jQuery. Over the last few weeks we've been working with the jQuery team to add great jQuery intellisense support within Visual Studio 2008 and Visual Web Developer 2008 Express (which is free). This is now available to download and ...


Kicked By:
Drop Kicked By:
0
kicks

I KILL-ed you! Now can I go for a coffee break while you die?  (Unpublished)

Find out how long it will take for a rollback to complete in SQL Server with the help of a little know feature of the KILL keyword.


Kicked By:
Drop Kicked By:
0
kicks

You Can Watch PDC'08 Sessions Online!  (Unpublished)

If you couldn't attend PDC'08 (like me) then you'll probably be interested in learning that you can go watch all the PDC'08 Sessions online for Free! This is awesome! Go Watch PDC'08 Sessions Online: https://sessions.microsoftpdc.com/public/timeline.aspx


Kicked By:
Drop Kicked By: