How to get sql server 2008 intellisense working for schema changes (cherupally.blogspot.com)

submitted by kcherupa(255) 1 month, 18 days ago

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 same session. This made me too bad and many times I cursed Microsoft for this inclomplete feature. But after making some research on this, I have found the solution to get ... read more...

add a comment | category: Database | Views: 1

tags: Server Schema 2008 Database SQL another

Download Sql Server 2008 R2 November CTP (praveenbattula.blogspot.com)

submitted by praveenbattula(395) 2 months, 20 days ago

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

add a comment | category: Database | Views: 1

tags: Server 2008 Database SQL another

SQL Server - How to get the whole group of duplicate rows (weblogs.sqlteam.com)

submitted by spirit1(3140) 3 months, 25 days ago

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

add a comment | category: Database | Views: 8

tags: SQLServer 2008 Database 2005 another

The 24 hours of PASS - SQL Server live webcasts (weblogs.sqlteam.com)

submitted by spirit1(3140) 6 months, 4 days ago

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

add a comment | category: Database | Views: 12

tags: SQLServer 2008 Database 2005 another

SQL Server 2005 – Fast Running Totals solution with ordered CTE update (weblogs.sqlteam.com)

submitted by spirit1(3140) 6 months, 12 days ago

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. read more...

add a comment | category: Database | Views: 23

tags: SQLServer 2008 Database 2005 another

How to check when was SQL Server installed with a T-SQL query (weblogs.sqlteam.com)

submitted by spirit1(3140) 6 months, 24 days ago

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

add a comment | category: Database | Views: 9

tags: SQLServer 2008 Database 2005 another

Visual Studio 2008 var Keyword Bug - Microsoft Follow-up (lakario.blogspot.com)

submitted by Lakario(60) 7 months, 1 day ago

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. read more...

add a comment | category: Visual Studio | Views: 20

tags: Bug 2008 var Studio VisualStudio another

SQL Server 2008 Extended Events - high performance eventing system (weblogs.sqlteam.com)

submitted by spirit1(3140) 8 months, 11 days ago

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. read more...

1 comment | category: Database | Views: 14

tags: SQLServer 2008 Database Performance another

SQL Server - Find missing and unused indexes (weblogs.sqlteam.com)

submitted by spirit1(3140) 10 months ago

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

add a comment | category: Database | Views: 33

tags: SQLServer 2008 Database 2005 another

Keyvan Nayyeri's Best Blog Posts in 2008 (nayyeri.net)

submitted by sharplife(4265) 1 year, 1 month ago

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. read more...

add a comment | category: Community | Views: 16

tags: KeyvanNayyeri 2008 Community .Net another

SSMS 2008 suggests missing indexes with actual execution plan (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 1 month ago

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! read more...

add a comment | category: Database | Views: 15

tags: 2008 SQLServer Database another

Advanced SQL Server 2005 Express Job Scheduling (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 2 months ago

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

add a comment | category: Database | Views: 63

tags: SQLServer 2008 Database 2005 another

jQuery Intellisense in VS 2008 - ScottGu's Blog (weblogs.asp.net)

published 1 year, 2 months ago, submitted by Tazer(350) 1 year, 2 months ago

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 use. read more...

add a comment | category: jQuery | Views: 333

tags: 2008 jQuery VisualStudio intellisense another

I KILL-ed you! Now can I go for a coffee break while you die? (weblogs.sqlteam.com)

submitted by spirit1(3140) 1 year, 3 months ago

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. read more...

add a comment | category: Database | Views: 12

tags: SQLServer 2008 Database 2005 another

You Can Watch PDC'08 Sessions Online! (pietschsoft.com)

submitted by crpietschmann(11.1k) 1 year, 3 months ago

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 read more...

1 comment | category: Community | Views: 18

tags: 2008 PDC08 Community PDC another

Microsoft PDC 2008: Day 1 Wrap-Up (dotnet.dzone.com)

submitted by alashcraft(1175) 1 year, 3 months ago

Ray Ozzie took center stage this morning at the Day 1 Keynote at PDC 2008 and everybody knew he had at least one surprise up his sleeve. read more...

add a comment | category: Events | Views: 5

tags: PDC08 2008 PDC another