Viewing 15 posts - 676 through 690 (of 754 total)
Check out Milleniata's M-Disc if you're interested in archival media (claims of 1000 years) for photos. Still only a maximum of 100GB/disc, and obviously no guarantees of the technology...
March 12, 2021 at 2:56 pm
Copy & swap should work. but don't forget to copy permissions too so that SQL Server has the same permissions to folders/files on the new drive.
March 10, 2021 at 2:08 pm
It won't impact anything that references the view (except when you have to drop & recreate it).
You have to drop & recreate schemabound view if altering source table(s): https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-ver15
Views or tables...
March 8, 2021 at 8:40 pm
Permissions are granted on schema, not individual tables: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-2016
Requires CREATE SEQUENCE, ALTER, or CONTROL permission on the SCHEMA.
GRANT CREATE SEQUENCE ON SCHEMA::Test TO [AdventureWorks\Larry]
March 5, 2021 at 7:27 pm
You can query sysjobs for sysjobsteps containing xp_cmdshell or using the CmdExec type:
SELECT * FROM msdb.dbo.sysjobs
WHERE EXISTS (SELECT * FROM msdb.dbo.sysjobsteps
...
March 2, 2021 at 5:16 pm
SELECT
reports.name AS ReportName,
Datasource.Name AS datasource
FROM dbo.Catalog reports
INNER JOIN dbo.DataSource ON DataSource.ItemID = reports.ItemID
WHERE reports.Type = 2
AND NOT EXISTS...
February 24, 2021 at 11:13 pm
To add to the idea of future-proofing, the OP might also want to consider using different ranges of IDs for related data to avoid ID collision and make merging into...
February 16, 2021 at 3:13 pm
Such as they are not really unique: https://www.nbcnews.com/technolog/odds-someone-else-has-your-ssn-one-7-6C10406347
February 12, 2021 at 8:00 pm
Page footer and/or Bottom margin. Assuming you don't have too much content to fit the page. If so, you might nee/want to reduce top margin or font sizes.
February 11, 2021 at 7:06 pm
No. Unless you use dynamic SQL, you will need to insert into a temp table or table variable -- e.g., via STRING_SPLIT() function -- and join to that table.
With STRING_SPLIT,...
February 9, 2021 at 7:52 pm
I fully expected this to fail with the trailing comma (after the "Kolicina" column).
Apparently it's a minor bug embraced as a feature: https://github.com/MicrosoftDocs/sql-docs/issues/4807
February 9, 2021 at 7:42 pm
The comparison to a constant acts like a where clause -- since they are inner joins, only rows where that condition is true will be included.
February 4, 2021 at 2:48 pm
So you are saying that SQL Saturday is only about live databases, not those used for reporting?
Not at all. Many of us do reporting using TSQL. MDX isn't the only...
February 3, 2021 at 5:20 pm
Note: Your example shows double quotes, not parentheses.
FIELDTERMINATOR=‘","’,
January 28, 2021 at 2:43 pm
If you're talking about passing a URL as a parameter, and then parsing a substring from that URL to use as the stored procedure parameter, then you would need...
January 27, 2021 at 9:38 pm
Viewing 15 posts - 676 through 690 (of 754 total)