Strangenut
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
April 2008 - SQL Server Blog
SQL Server Blog
Home
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Writing Your First CLR Stored Procedure
How to enable CLR Stored procedures on SQL Server 2005 and 2008
Making the case for stored procedures
Getting a range of values from an arbitrary starting point in T-SQL
The Basics of Database Normalization - Explained
Tags
beginner
c#
CLR Stored Procedures
database
IIS7
Indexes
performance tuning
query execution plans
scott gu
silverlight
SQL Server
stored procedure
T-SQL
xaml
View more
News
Why don't you take a few minutes to join Strangenut, I'm trying to build an interactive community and would love to have your feedback on what I write and suggestions and questions I can answer! It's free, I won't spam you, and won't sell your address to anyone!
Programming
Scott Gu's Blog
DotNetSlackers
VisitMIX
Archives
October 2008 (3)
August 2008 (1)
July 2008 (1)
June 2008 (1)
May 2008 (1)
April 2008 (6)
February 2008 (3)
Sort by:
Most Recent
|
Most Viewed
|
Most Commented
Paging and Available Memory for Operating system, what you need to know?
Found this great article on interpreting PERFMON statistics. Being able to make sense of this is critical to doing advanced performance tuning on your SQL Server. This type of stuff goes more towards system administration more than programming. I myself...
Published
Sat, Apr 26 2008 9:43 PM
by
dacrowlah
Filed under:
performance tuning
,
database
,
SQL Server
New Log Reporting, Database Management, and other cool admin modules for IIS 7
Found this post over on ScottGu's blog today, highlights some of the new featuresof IIS7. Man, I can wait to play with this! From Scotts blog: One of the core priorities we focused on when building IIS 7 was to enable a rich .NET extensibility model...
Published
Sat, Apr 26 2008 9:01 PM
by
dacrowlah
Filed under:
scott gu
,
IIS7
Just a quick post for Easter 2008
Ok, so it's a little late, but just uploaded some pics of me and some friends at Dolores Park in San Francisco dressed as easter peeps. There is also a YouTube video with many cameos of us :-)
Published
Mon, Apr 14 2008 12:58 AM
by
dacrowlah
ClearTrace - great free tool for troubleshooting database performance issues
ClearTrace is a free tool available for download that will analyze SQL Server trace files and trace tables to give you a normalized view of query performance. It offers various sorting capabilities From the site: ClearTrace imports SQL Server 2000 and...
Published
Thu, Apr 10 2008 8:06 PM
by
dacrowlah
Filed under:
performance tuning
,
database
,
SQL Server
How to manually override the path of a full-text index in SQL Server
Recently I had to migrate our primary databases to a new server. Yaay for the faster hardware, everything went smoothly until the next day when users started reporting that searches were failing. Turned out to be the full text catalogs do not move over...
Published
Thu, Apr 10 2008 6:41 PM
by
dacrowlah
Query to get the parameter list along with datatypes and maxlength for SQL 2005
Today we had a need for a query that would return information on a stored procedure and give us a list of parameters, datatypes, and max values. This functionality is built into the data adapter but we wanted a little bit more flexibility on how we used...
Published
Thu, Apr 10 2008 3:24 PM
by
dacrowlah
Filed under:
T-SQL
,
database
,
SQL Server
,
stored procedure