Search
-
how to find gap in a range.
I use sql 2012 but, one can answer up to 2019 create table t ( b decimal(13,4) not null, c decimal(13,4) not null); Insert into T (B,C) values ( 1,200); Insert into T (B,C) values ( 200 ,400); Insert into T (B,C) values ( 600, 900); create table t1 (b decimal(13,4) not null, c decimal(13,4) not null); Insert into t1 (B,C)… -
Flyway command line FIPS enable & compliant chagnes
Was going through the Flyway Command line Github & Document however didn;t found any configuration related to FIPS changes Could someone please point to wiki if any available or share command line. GitHub - https://github.com/flyway/flyway it would be also fine to build it, if instruction provided with patch of code… -
Database unable to restore - error 3257
I am evaluating SQL Backup but running into a critical failure on attempting to backup and then restore a database back to where it came. The database is large and split amongst multiple disks that are mount points (many of our systems in-house use too many disks to use letters). Backup runs fine, but restore errors at… -
Thanks for the T-Shirt!
Discussion by Uwe Keim · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsAs you can see here your package with the t-shirt has just arrived :D . Thanks for it! Uwe -
Recovery Pending not fixed by Restarting SqlClone Agent
We have two clones remaining in "Recovery Pending" after a system reboot. According to SQL Cloned DB goes into recovery state after reboot. — Redgate forums (red-gate.com), this would be fixed by restarting the SQL Clone Agent service on the server. Doesn't make a difference. The Clone Dashboard no longer reports this… -
Re: Compare 10.2 and localDB in MSSQL2012
-
Re: Refresh suggestions
Hi Krzysztof! Maybe I am wrong but the logic considering your approach should be: CREATE TABLE t(col1 int) -- correct suggestion although the table is not created SELECT * FROM t DROP TABLE t; -- after dropping the table logically (in the script but no execution) or physically the -- table t should not be listed in the… -
Tables With Index Differences Showing Up As Identical
-
Alias doesn't seem to work for DELETEs
Hi, When I type the period at the end of this code snippet "SELECT * FROM mytable t WHERE t." then I am presented with the candidate list showing all columns in mytable. All good. When I type: "DELETE FROM mytable t WHERE t." then I do NOT get the candidate list with just my columns. In fact it shows jsut about everything… -
Re: Allow embedding any assembly
>1648 results