RE: bcp utility problem
What is the actual value of <zero-length value>If it contains 026 0x1A, then it represents ascii eof and the file will seem truncated to certain applications.
2005-02-09
SQL Server on Linux
2005-02-04
Best way to query data....
I have a table with the date and data elements in it.I need to produce a resultset in the following manner:On columns: Yesterday, WeekToDate, MonthToDate, Last Month, YearToDateOn rows: data element 1, data element 2, data element 3, ....What's the best way to query this table? It has to be fast for the front end.Thank […]
2005-01-25
Backup Error
Hi On several occassions, when doing SQL backups, I receive the following message - "The file on device 'tapedump1' is not a valid Microsoft Tape Format". These DLT tapes have previously been used for sql backups. I then format the tape in Windows, try again and sometimes the backup works, and sometimes I get the same […]
2005-01-17
RE: WHERE IN(sub-query) vs. INNER JOIN
I had read an article about using "exists" instead of "In". I think it mentioned that exists would just check for a condition to find out if its true or false; but "In" clause actually retrieves a result set and hence is much slower.
2004-12-15
RE: LinkedServers and Views
I have tried that but have been getting this error.Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema. OLE DB error trace [Non-interface error].I have been able to query the linked server from […]
2004-12-15
Reinstalling OS
Hi, I want to reinstall OS on one of the clustered nodes(Node1) since it is giving us problems. My question is how do we do this, Can we take node1 offline after moving all the resources to Node2 and than uninstall the OS and reinstall the OS and connect to the cluster. Is this possible? […]
2004-12-02
RE: Are you innovating?
I agree: Good article, Andy.I'm looking forward to the traffic signal showing how much time is left on the YELLOW (and maybe even FLASHING THE RED to STOP! STOP! STOP! before going solid Red) so drivers stop running Yellow lights and killing people when the light is Red.Thanks for encouraging us to slow down and think. Enjoy life.
2004-10-04
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers