Monday, January 31, 2005
Index Tuning Wizard problem - "An error occurred trying to execute a SQL statement."
Index Tuning Wizard problem: " 'An error occurred trying to execute a SQL statement.'"
Thanks to your suggestion, I was able to identify the problem -
it seems the ITW has a problem working with tables that have
fields that have a single quote in them. Bug for MS to fix,
I guess.
Thanks to your suggestion, I was able to identify the problem -
it seems the ITW has a problem working with tables that have
fields that have a single quote in them. Bug for MS to fix,
I guess.
Thursday, January 27, 2005
Working with SQL Server 2000 Management Tools and Utilities
Here's how to get a comma separated output from Sql Server. Use -s
Working with SQL Server 2000 Management Tools and Utilities
Working with SQL Server 2000 Management Tools and Utilities
Tuesday, January 25, 2005
Friday, January 21, 2005
Internet Telephony Product Reviews: Avaya's IP Office WHAT A JOKE!!!
Internet Telephony Product Reviews: Avaya's IP Office
Give me a break! A features rating of 5? This Avaya IP Office is a piece of junk. Our old Merlin legend had more useful features than this thing. Our old Merlin worked, which is not true of IP Office.
A voice mail system with no broadcast messaging? What are these guys thinking?
Give me a break! A features rating of 5? This Avaya IP Office is a piece of junk. Our old Merlin legend had more useful features than this thing. Our old Merlin worked, which is not true of IP Office.
A voice mail system with no broadcast messaging? What are these guys thinking?
Thursday, January 20, 2005
Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats
http://www.databasejournal.com/features/mssql/article.php/2197931
Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats: "PRINT '1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>' +
CONVERT(CHAR(19),GETDATE())
PRINT '2) HERE IS MM-DD-YY FORMAT ==>' +
CONVERT(CHAR(8),GETDATE(),10)
PRINT '3) HERE IS MM-DD-YYYY FORMAT ==>' +
CONVERT(CHAR(10),GETDATE(),110)
PRINT '4) HERE IS DD MON YYYY FORMAT ==>' +
CONVERT(CHAR(11),GETDATE(),106)
PRINT '5) HERE IS DD MON YY FORMAT ==>' +
CONVERT(CHAR(9),GETDATE(),6)
PRINT '6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>' +
CONVERT(CHAR(24),GETDATE(),113)
Here is the output from the above script:
1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>Feb 5 2003 5:54AM
2) HERE IS MM-DD-YY FORMAT ==>02-05-03
3) HERE IS MM-DD-YYYY FORMAT ==>02-05-2003
4) HERE IS DD MON YYYY FORMAT ==>05 Feb 2003
5) HERE IS DD MON YY FORMAT ==>05 Feb 03
6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>05 Feb 2003 05:54:39:567"
Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats: "PRINT '1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>' +
CONVERT(CHAR(19),GETDATE())
PRINT '2) HERE IS MM-DD-YY FORMAT ==>' +
CONVERT(CHAR(8),GETDATE(),10)
PRINT '3) HERE IS MM-DD-YYYY FORMAT ==>' +
CONVERT(CHAR(10),GETDATE(),110)
PRINT '4) HERE IS DD MON YYYY FORMAT ==>' +
CONVERT(CHAR(11),GETDATE(),106)
PRINT '5) HERE IS DD MON YY FORMAT ==>' +
CONVERT(CHAR(9),GETDATE(),6)
PRINT '6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>' +
CONVERT(CHAR(24),GETDATE(),113)
Here is the output from the above script:
1) HERE IS MON DD YYYY HH:MIAM (OR PM) FORMAT ==>Feb 5 2003 5:54AM
2) HERE IS MM-DD-YY FORMAT ==>02-05-03
3) HERE IS MM-DD-YYYY FORMAT ==>02-05-2003
4) HERE IS DD MON YYYY FORMAT ==>05 Feb 2003
5) HERE IS DD MON YY FORMAT ==>05 Feb 03
6) HERE IS DD MON YYYY HH:MM:SS:MMM(24H) FORMAT ==>05 Feb 2003 05:54:39:567"
Wednesday, January 19, 2005
Sql Reporting services "report item expressions can only refer"
When you get the message "report item expressions can only refer ...", make sure the variables you are referrering to are the right CASE.
The case must match the output case from the sql output. Even in VB!!!
The case must match the output case from the sql output. Even in VB!!!
Tuesday, January 18, 2005
OOP in .NET: the How and Why
OOP in .NET: the How and Why: "when they are not appropriate. The fact is that there are few if any situations where you could not use OOP to good advantage. After all, any code that you could use outside of an object can also be placed within a class. It does take a bit of time to adjust to the OOP mindset so that you start thinking in terms of classes and objects as soon as you start planning a program. As you plan, think of the program's functionality in terms of both data storage and actions, and you'll start to see some of the data units and tasks that are naturals for encapsulation in a class. "
Comcast to raise broadband speed | CNET News.com
Comcast to raise broadband speed | CNET News.com: "Comcast to raise broadband speed"