RE: Converting hex to int
Guess I was asleep when I looked last time. Chris, David, timingskey - thanks to each of you. Plenty of options now. Guarddata-
2003-07-25
Fuzzy Match
RE: eliminating duplicates from stored procedure joins
You need some sort of hierarchical display for the data: you could try outputting as XML, and using an XSL stylesheet to display the data (or for intranet on IE, use an XML data island and javascript) - or most simply, just have one page for the Case IDs, and when the caseID is clicked, […]
2003-06-24
RE: eliminating duplicates from stored procedure joins
The reportid and viewid are mainly used for linking the files with the resultset for user to view those files.
2003-06-24
RE: Transaction log backup failing
Maybe you have the select into/bulk copy option checked in your db, and operations like bulk insert, bulk copies, truncate tables are made against it. This kind of operations are non-logged. By the way, who knows all the operations that doesn´t log?
2003-06-10
RE: How to place a record set from a SP to temp table?
What if it returns two or more record sets, like sp_helplogins?
2003-06-10
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
Database copies (cross environment) and sizing strategies for 2019
I'm sure this has been asked many, many, many times and hoping several optimal...
TSQL to determine status of subscription reinitialization
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
migration
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC