Forum Replies Created

Viewing 15 posts - 106 through 120 (of 223 total)

  • RE: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

    In the project file, Configuration Properties, Debugging, there is an option to set 64 bit debugging to true or false. Once it was set to false, I stopped receiving the...

    Jamie

  • RE: Query cost

    This is a great question.

    It took C# (formerly a vb programmer here) to teach me that collections work quite efficiently using delegates and predicates and, bearing this concept...

    Jamie

  • RE: SSRS snapshot

    While on the subject of reports, anyone have trouble with slow response? We keep blaming it on the portal.

    Jamie

  • RE: What's a Toaster?

    Winzip had me at Hello but v14? wow, I am still using a registered copy of v9.

    Oh, and of course, I should mention my toaster oven is Windows.

    Jamie

  • RE: SQL 2K5 - Table-Valued Parameters

    I've often wished the QOTD in the email included the title and it can't be that hard to include it.

    I often think of a format change but not necessarily...

    Jamie

  • RE: SQL 2K5 - Table-Valued Parameters

    Seems so simple, but can be confusing... is this the purpose of symantics?

    Jamie

  • RE: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

    I did not mess with the 64 bit MDAC... the version on server 2008 was higher than the listed MDAC patch so I believe the problem lay elsewhere.

    I checked a...

    Jamie

  • RE: Merry Christmas 2009

    Same... this is a great site!

    Jamie

  • RE: ^ : T-SQL

    I took the approach that the answer was easy. Not a wise approach. Good subject.

    Jamie

  • RE: Largest Unit

    Sounds like you were sucked in... what exactly are you trying to discover? Maybe we can help.

    Jamie

  • RE: Conversion failed when converting datetime from character string.

    Susan,

    You list 06-30-2007 and 2007-10-10 as the format.

    Not sure if this will help as it is an answer that has only been checked for SQL Server 2008. (not to...

    Jamie

  • RE: BACKUP / RESTORE

    This question was poorly written and since I first started writing them because I found poorly written questions could throw me off easily, I vowed to fix this. My...

    Jamie

  • RE: SQL 2008 T-SQL

    Excellent question.

    First because it demonstrates the MERGE,

    Second because it illustrates the $action, and

    Last because the format for the output makes the answer particularly clear.

    Specifically:

    INSERT6ProductionJonesNULLNULLNULL

    UPDATE2SalesErickson2SalesByham

    DELETENULLNULLNULL5ManufacturingBrewer

    Nice one!

    Jamie

  • RE: FILESTREAM

    Enabling FILESTREAM at the Windows level installs a file system filter driver, which is something that only a Windows administrator has privileges to do.

    I tested FILESTREAM and did nothing to...

    Jamie

  • RE: Snapshots

    http://www.sharepointblogs.com/wsspectacular/archive/2009/03/10/sql-2008-annoyances.aspx

    Part of what this question attempts to point out is there is a long list of features available in the Enterprise version NOT available in the Standard version.

    The CIO would...

    Jamie

Viewing 15 posts - 106 through 120 (of 223 total)