By tag: 2008
0
kicks
How to get sql server 2008 intellisense working for schema changes
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...
0
kicks
Download Sql Server 2008 R2 November CTP
Get the latest version of Sql Server 2008 version R2 [CTP]
0
kicks
SQL Server - How to get the whole group of duplicate rows
A fast way how to get the whole duplicated group of rows in Sql Server 2005 and up.
0
kicks
The 24 hours of PASS - SQL Server live webcasts
This years biggest online SQL Server related event. It will last full 24 hours.
Don't miss it!
0
kicks
SQL Server 2005 – Fast Running Totals solution with ordered CTE update
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.
0
kicks
How to check when was SQL Server installed with a T-SQL query
Sometimes you might want to check when was SQL Server installed witha query. this is how you do it.
0
kicks
Visual Studio 2008 var Keyword Bug - Microsoft Follow-up
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.
0
kicks
SQL Server 2008 Extended Events - high performance eventing system
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.
0
kicks
SQL Server - Find missing and unused indexes
How to find SQL Server indexes that should exists and those that shouldn't when performing index maintenance.
0
kicks
Keyvan Nayyeri's Best Blog Posts in 2008
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.
0
kicks
SSMS 2008 suggests missing indexes with actual execution plan
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!
0
kicks
Advanced SQL Server 2005 Express Job Scheduling
How to make run once, daily, weekly, monthly absolute and relative scheduling in SQL Server Express 2005 and 2008 without any 3rd party tools.
0
kicks
jQuery Intellisense in VS 2008 - ScottGu's Blog
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 ...
0
kicks
I KILL-ed you! Now can I go for a coffee break while you die?
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.
0
kicks
You Can Watch PDC'08 Sessions Online!
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