Hi. The Transact-SQL script below returns the following information: ID – Just an identity column used within the script SchemaName – The name of the schema TableName – Obviously, the name of the table 🙂 ColumnName Type – The data type of the column Length – The maximum number of bytes used by the field […]
Over the past month or so, I have been working on upgrading an Endeca system that currently processes about 150,000 records. The current system runs on Endeca MDEX Engine v5.1.3. The latest version at the time of writing this post, is 6.1.4A. I decided to work on a VirtualBox Virtual machine, running Windows Server 2008 R2. […]
I wanted to produce a list of the MAX of date fields (DateTime, SmallDateTime, TimeStamp) for all tables within all databases held in an instance of SQL Server.
The script below was written for SQL Server 2000, but should be easily customisable for SQL Server 2005
Yesterday, I was trying to install Virtual PC for Windows 7, but it was taking ages to install. I even left it running overnight, but all it said, was:
“Initializing installation… done!”
“Installing Update for Windows (KB958559) (update 1 of 1)…”
The Transact-SQL Script below, is useful if you want to standardise the location of your databases. I have been managing a server whereby databases created by other people were created all over the place!! Therefore, this script was written to make life so much easier. 🙂 Be sure to read through the script before running it. […]
Earlier today, I discovered that the database maintenance plan on one of our SQL Server machine wasn’t working. When I reviewed the logs, it simply said “sqlmaint.exe failed”.
Hi. I have a .NET web site using Endeca, that references a three-level externally managed dimension. An example of this dimension is: Level 1: Dairy free, meat free, gluten free Level 2: Meat free Level 3: Tofu Level 2: Dairy free … However, because there are no results for Meat free or Tofu, these are […]
The query within this post returns the top 20 most used query plans that are cached by SQL Server for faster query execution.
I was on a training course at the end of September, and came across a way to execute a simple stored procedure as part of a select statement using an Inline Table Valued Function.
You (like me) have probably tried to run the following statement expecting to get results from a stored procedure:
Earlier today, one of the database servers that I manage wasn’t responding. This turned out to be due to a Windows Update that caused the server to restart, but the server didn’t come back properly. We restarted the server again and it seemed OK. Because this happened in the middle of an Endeca “Baseline Update”, […]
This is a test for the “Display as Asides” feature in WordPress 🙂
Yesterday I was trying to split an image into 9 separate parts using Microsoft Word 2010, so I could print them out, and when put together would be about the same size as an A2 piece of paper. But I just could not work it out!!! In Word 2007, the settings were straight forward. Just […]