RE: eliminating duplicates from outer join query
Also the select distinct is not required - union would return distinct rows by itself
2003-06-19
Restore
2003-06-16
1 reads
RE: MSDE Backup
From DOS. C:\OSQL.exe -Syourservername -E Once you login to SQL Server, Run following statemnet. >backup database yourdbname to disk = 'c:\temp\yourdbname_date.bak'
2003-06-12
RE: log file too big
problem solved. sp_repldone. No need to unpublish and publish as BOL indicates.(from Microsoft)
2003-06-10
1 reads
RE: 7x24 support in a Merge replication environment
Look at the locks. During the data reorgs there will b exclusive locks on the table.
2003-06-06
RE: INFORMATION_SCHEMA
Try the system stored procedure sp_helptext. For instance: EXEC sp_helptext MyView K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-05
1 reads
RE: Null date from Access
will the following changes make a difference : if Trim(me.txtDate) = "" then strDate = "NULL" else strDate = " ' "&me.txtDate&" ' " end if and then reference "&strDate&" in the ADO - i.e without the single quotes...
2003-06-05
1 reads
RE: SQL Perf Counters Lost
please see knowledge base article q248993. problem lies in the registry, there is a tool you can then download to hack the registry and get your coutners back.
2003-06-03
1 reads
RE: SqlServerAgent fails
This is the error I get when I try to start sql server agent: "Could not start the SqlServerAgent on Local Computer. The service did not return an error. This could an interanl Windows error or internal service error. If the problem persists, contact your system administrator."
2003-05-08
1 reads
Blogs
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...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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