Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
DevCast
Keith Rull
»
All Tags
»
SQL
(
RSS
)
ATTENTION
: I've decided to put the upgrade on hold due to a compatibility issue of our server environment with the latest CS installer package. CS 2008 now requires SQL Server 2005 as the backend DB but our database server currenlty has SQL Server 2000 installed on it. I'll resume the upgrade once I figure out when Telligent is releasing a patch to the schema compatibility issue. For now, we will continue to use the old version of CS while waiting for the said patch. If you have any questions about this process, please don't hesitate to post them on our forums and I'll answer them as soon as I can. Thanks for your patience and support guys! I'll let you know as soon as this is resolved. -
Keith Rull
Browse by Tags
Keith Rull
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Refreshing views with sp_refreshview
sp_recompile is your friend
Some useful date processing SQL Snippets
How To: List databases in a SQL Server using T-SQL and truncate their logs
How to: Get a list of fixed drives and their free space inside SQL Server
Tags
.NET
.NET How To's
ASP.NET
Blog News Node
C#
Contest
Filipino Developer
Filipino Podcast
Filipino Programmer
Fun Stuff
Geek Fun
Generics
GridView
How To
Java
My .Net Exploits
Pinoy
Pinoy Podcast
Pinoy Programmer
Promos
Site News
SQL
Tutorial
VB.NET
Your Career
View more
News
Badges
Archives
November 2008 (1)
October 2008 (4)
September 2008 (8)
August 2008 (4)
July 2008 (2)
June 2008 (8)
April 2008 (4)
March 2008 (8)
February 2008 (8)
January 2008 (9)
December 2007 (9)
November 2007 (23)
October 2007 (3)
September 2007 (5)
August 2007 (5)
July 2007 (1)
June 2007 (3)
May 2007 (11)
April 2007 (1)
March 2007 (9)
February 2007 (8)
January 2007 (2)
December 2006 (2)
November 2006 (1)
October 2006 (8)
September 2006 (9)
August 2006 (5)
July 2006 (1)
June 2006 (10)
May 2006 (10)
April 2006 (11)
March 2006 (9)
February 2006 (20)
January 2006 (17)
December 2005 (7)
November 2005 (1)
October 2005 (4)
September 2005 (4)
August 2005 (4)
July 2005 (4)
June 2005 (4)
March 2005 (3)
.NET Data Providers
.NET How To's
DataTable
Date Processing
DBCC
DBProviderFactories
GetFactoryClasses()
SHRINKDATABASE
Snippets
sp_databaases
sp_helpdb
sp_msForEachDB
sp_MSforeachtable
sp_recompile
sp_refreshview
SQL Helpers
SQL Server
SQL Tips
SQL Tricks
SQL utilities
sys.sysdatabases
sysdatabases
Truncate Database Logs
Truncate Table
T-SQL
Useful SQL Scripts
xp_fixeddrives
Refreshing views with sp_refreshview
One of the common problems that you would encounter when you are building applications that utilize views is that sometimes there are cases wherein a view gets out of date. This happens when you add a new column to a table a view is refrencing. To fix...
Published
Tue, Aug 08 2008 12:00 PM
by
keithrull
Filed under:
SQL
,
SQL Tricks
,
SQL Helpers
,
SQL Tips
,
sp_refreshview
sp_recompile is your friend
I've been doing a lot of code deployments lately and I've come across several occasions wherein my stored procedures wouldn't run as fast as expected compared to it's previously known execution time. The problem lies on the statistics...
Published
Tue, Aug 08 2008 11:47 AM
by
keithrull
Filed under:
SQL
,
sp_recompile
,
SQL utilities
,
SQL Tricks
,
SQL Helpers
Some useful date processing SQL Snippets
Here's an update to my blog entry 3 years ago regarding the same topic: ---Calculates the first day of the previous month SELECT DATEADD (mm, DATEDIFF (m, 0, GETDATE ()) - 1, 0) AS [First day of the previous month ] ---Calculates the first day of...
Published
Thu, Jul 07 2008 11:44 AM
by
keithrull
Filed under:
SQL
,
SQL Server
,
Date Processing
,
Snippets
,
Useful SQL Scripts
How To: List databases in a SQL Server using T-SQL and truncate their logs
Finally i'm back after a month of crazyness due to my webhost not performing up to its promise of 99.9% uptime. Enough with the rant and on with the article, today i'm going to talk about how to list databases in a SQL Server by just using T-SQL...
Published
Tue, Jan 01 2008 11:59 AM
by
keithrull
Filed under:
SQL
,
T-SQL
,
sp_MSforeachtable
,
Truncate Table
,
DBCC
,
sysdatabases
,
sys.sysdatabases
,
Truncate Database Logs
,
SHRINKDATABASE
,
sp_msForEachDB
,
sp_databaases
,
sp_helpdb
How to: Get a list of fixed drives and their free space inside SQL Server
I didn't know that I could do this inside SQL Server EXEC master.. xp_fixeddrives Executing the procedure onmy server gave me this result set: drive MB free C 5897 E 33334 Man, I think it's about time I upgrade and brush up my SQL skills. I don't...
Published
Fri, Sep 09 2007 11:30 AM
by
keithrull
Filed under:
SQL
,
xp_fixeddrives
How To: List All Available .NET Data Providers
.NET 2.0 introduces to us the class known as DBProviderFactories which enables us to access available providers on a machine. the DBProviderFactories class has method called GetFactoryClasses() that returns a DataTable that contains any class that is...
Published
Sun, Aug 08 2006 2:51 PM
by
keithrull
Filed under:
.NET How To's
,
SQL
,
DataTable
,
.NET Data Providers
,
GetFactoryClasses()
,
DBProviderFactories
HowTo: List Database Objects in SQL Server using sysobjects, syscolumns and systypes
I have been working more and more with data recently and its a painstaking task. Alot of my time includes analysis of trades and financial information to create and calculate error free result sets. This also includes data cleanup.....
Published
Sat, Jun 06 2006 1:52 PM
by
keithrull
Filed under:
SQL
Copyright DevPinoy 2005-2008