Viewing 15 posts - 166 through 180 (of 1,418 total)
I have not needed to do this but can think of two options to get live Oracle data; neither of them are particularly appealing.
Option one:
May 6, 2023 at 5:56 pm
Our network team have just installed their new backup system, called Cohesity, on one of our servers. It seems to work in a similar way to Datto. My backup routine...
April 18, 2023 at 10:38 am
,ROW_NUMBER() OVER (ORDER BY datalc, cm desc) AS RowNum
Using the above on 20140812 the first cm (RowNum = 1) will be 98 so your rules make the...
April 18, 2023 at 9:41 am
Seemed to double post
April 18, 2023 at 9:40 am
I didn't have a problem with it. If you want condescending, you have to read some Joe Celko posts.
For someone with a mathematical background, I do not think Joe...
April 18, 2023 at 8:14 am
Okay Phil Parkin criticizing a questioner is poor etiquete.
Umm.... The OP has form. I would say that repeatedly not providing DDL and test data is poor etiquette.
April 18, 2023 at 7:24 am
I want to align a Date column (datetime2(7)) with the same full resolution date of SysStartTime column populated by SQL in temporal tables.
Maybe I am misunderstanding something but why...
April 4, 2023 at 4:05 pm
The text data type has been depreciated for sometime and the remarks in the following state that CHARINDEX cannot be used with image, ntext, or text data types.
https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16
I suspect...
April 3, 2023 at 10:27 am
I know this is old, but is there STILL no way to do this?
Maybe.
You could try looking at row level security (RLS) on sys.databases but I suspect this will...
March 28, 2023 at 10:30 am
"cannot specify included columns for a clustered index"
As the clustered index contains all the columns why would you want to include them?
I have a script that was running...
March 20, 2023 at 9:07 am
ps FYI I have just learnt that our sysadmin team now have a CA server from which to issue certificates for our LAN. They are also happy to handle the...
March 15, 2023 at 3:34 pm
No such actions were performed.
- No backups running outside the software.
I presume you have double checked this by looking at the tables in MSDB:
SELECT S.backup_start_date, S.backup_finish_date,...
March 14, 2023 at 6:39 pm
Viewing 15 posts - 166 through 180 (of 1,418 total)