Viewing 15 posts - 1,591 through 1,605 (of 22,202 total)
The best licensing answers are always going to come from Microsoft itself, not some Yahoo on the internet.
That said:
September 24, 2020 at 11:06 am
I'd have one word:
Don't.
That's the best advice on how to store a file inside SQL Server.
Can you do this? Yes. The link provided above will give you the details. Should...
September 23, 2020 at 1:08 pm
You can't just change the IP address locally. That has to go through however you're administering IP addresses within your system. Then, yes, once that IP address changes, you'll have...
September 23, 2020 at 1:04 pm
Hi @Grant Fritchey thanks for your support, I tried the query but the result are empty, how it is possible?
SELECT
name AS 'Constraint',
is_disabled,
is_not_trusted
FROM sys.foreign_keys
WHERE is_disabled = 1;
Regards.
You may not have...
September 22, 2020 at 6:21 pm
I did a quick search and found this. It'll tell you if there's a disabled fk or one using WITH NO CHECK (untrusted). That should get you pretty far...
September 22, 2020 at 1:23 pm
First, are all the FKs enforced on the primary database? Is it possible that you have data problems and the scripts are disabled or built using WITH NOCHECK and your...
September 22, 2020 at 11:44 am
Let's assume that you need nolock everywhere <sigh>, instead, use READ_UNCOMMITTED at the connection. That way, when you find that all the bad data being returned by nolock is causing...
September 22, 2020 at 11:39 am
It is possible though that the backup has more than one database inside of it. You can query the file to find out if there's an issue.
September 21, 2020 at 1:29 pm
Sounds like you want to find the rows where a column (or columns) actually have data, meaning, they're NOT NULL. If that's what you're looking for, then that's the phrase...
September 18, 2020 at 11:37 am
I see nothing wrong with such a DDL trigger to detect when a new database was created... but I wouldn't rely on it to make sure backups are performed. ...
September 17, 2020 at 5:29 pm
Much better would have been to create an SSMS server group(s) with all the relevant servers in it(them), then fire off the script for a given server group(s) whenever...
September 17, 2020 at 11:33 am
That's a great story, Grant, and I 100% agree that's was an appropriate use of PowerShell. The question is, would you have been comfortable in letting someone who didn't...
September 17, 2020 at 11:31 am
If the users can add/remove columns to a table at will, I would actually consider this a good candidate for an EAV table.
This!
September 16, 2020 at 2:24 pm
You're not going to be able to get around the need for a lock to perform DDL. No matter what. Again, it sounds like architecture is more of the problem....
September 16, 2020 at 12:42 pm
Total agreement with everyone else that you should be spotting when new databases are created. However, it's entirely possible to create a backup script (or use Minion or Ola Hollengren's...
September 16, 2020 at 11:35 am
Viewing 15 posts - 1,591 through 1,605 (of 22,202 total)