Do you want to execute a Stored Procedure as part of a SELECT statement??

0
1 year ago
in
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: USE [...]

Endeca – “Unknown Host Exception using eaccmd”

0
1 year ago
in
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 [...]

Just testing the “Display as Asides” feature in WordPress

3
1 year ago
in
This is a test for the “Display as Asides” feature in WordPress

Word 2007 and 2010 Crop Settings

0
1 year ago
in
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 specify the [...]

SQLBits – The 7 Wonders of SQL

0
1 year ago
in
www.sqlbits.com SQLBits – The 7 Wonders of SQL conference, is taking place from September 30th to October 2nd at York University. SQLBits is the largest SQL Server conference in Europe and the previous six conferences have established it as a must-attend event for DBAs, developers and BI [...]

FREE Level 400 SQL Server Performance Monitoring and Tuning Webcasts

0
1 year ago
in
FREE Level 400 SQL Server Performance Monitoring and Tuning Webcasts at http://www.sqlworkshops.com/webcast This is a great resource for performance monitoring and tuning

List of tables and indexes, with associated File Group

0
1 year ago
in
The script below (written using SQL Server 2005), returns a list of all tables (along with the schema name), and indexes (where they exist), and the name of the associated file group. This will useful to find out which objects have been assigned to the wrong file group. I have a database with over [...]

Search all table columns for specific text

0
1 year ago
in
I needed to find out which columns within all tables in the database, contained a specific string of text. I therefore wrote the script below to do exactly that CREATE TABLE TempTableColumnResults ( TableName VARCHAR(100),   ColumnName VARCHAR(100) ) DECLARE @TableName VARCHAR(100) DECLARE [...]
Go to Top