|
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 Blog Posts by Tags
All Tags » SQL (RSS)
-
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 this some people would delete the view and recreate...
-
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 not getting updated after change has been made against...
-
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 current month SELECT DATEADD (mm, DATEDIFF (m, 0,...
-
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 and then showing you how to truncate the logs on...
Posted to
Keith Rull
by
keithrull
on
01-22-2008
Filed under: Filed under: SQL, T-SQL, sp_MSforeachtable, Truncate Table, DBCC, sysdatabases, sys.sysdatabases, Truncate Database Logs, SHRINKDATABASE, sp_msForEachDB, sp_databaases, sp_helpdb
-
we have a number of batch scripts at work which executes sql-related tasks for each of our project releases. last time, i incorporated errorlevel checks so we know if there was a problem with the execution and in order to abort the rest of the operations if something else has gone wrong. i was surprised...
-
I came across this error ORA-00904 : "GetTotalItem": invalid identifier when I tried to call a local function inside a dynamic query. I am currently working with Oracle database (we’re using Oracle 9i). My task is to add additional field (TotalItem) in the existing query in the StoredProc1...
-
My current task in our project is majorly in MSSQL. I wanted to debug a chain of stored procedures and I have just found out that MS has removed debugging tools out of SQL Server 2005 client tools and relied more on visual studio's. I have experienced debugging both from SQL Server 2005 Query Analyzer...
-
Not being an SQL guy, i'm really not used to implicit commands from T-SQL. By implicit, I mean those simplified commands which does the same thing as those documented in every SQL books. I first encountered a query below from a teammate: FROM Table1 T1 JOIN Table2 ON ... Every book includes all those...
Posted to
jokiz
by
jokiz
on
09-11-2007
Filed under: Filed under: SQL
-
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 know why you would do it inside SQL Server...
-
In one of the website I have developed, we feature random products displayed on a webpart. This can be done several ways either of the code behind or via t-sql but I think the simplest way to do it is via t-sql with the help of Guid columns. Globally Unique Identifier or GUID is a randomly generated...
-
My boss is optimizing one of our previous projects. He was specifically looking at the queries used by NHibernate and he noticed that the generated sp_executesql queries are using nvarchar parameters. The query was just a filter for just one column (Position) and he noticed that the index for the said...
-
unique constraints are very common for database table designs in applications nowadays. there are two ways to safely code an application to cater for this unique constraint requirement. (1) do an existence check/query before doing the insert. (2) let the database throw a unique constraint and handle...
-
i once joined a team in developing a procurement/bidding system in ASP.NET. it involved "project for bidding" creation, contractor's profile management (with lots of document uploads), and bid evaluation as the core functionalities. contractors have the option to change any of its profile ranging from...
-
most of our .NET projects has a database project with three scripts in it, (1) create database script, (2) database shema script and the (3) default data script. for our pre-release, we packaged the database creation with default data in our Installshield project so we made use of the SQLScripts section...
-
I previously posted my views regarding @@IDENTITY variable and SCOPE_IDENTITY() functions in sql server here and luckily with the single stored procedure in our project using NHibernate, i was able to revisit some of its definitions. My teammate whom i asked help from in developing the said stored procedure...
|
|
|