Viewing 15 posts - 16 through 30 (of 690 total)
Don't. Use SQL Server Reporting Services or some other external service.
February 28, 2024 at 6:59 pm
Best practice: Don't truncate your transaction log, except in unanticipated emergencies where you have run out of storage, and the cost of waiting to add storage exceeds to cost of...
February 23, 2024 at 8:47 pm
Has anyone applied any SQL Server CUs to that server in February?
What does SELECT @@VERSION return?
February 21, 2024 at 8:14 pm
I'd rather strongly recommend a separate note table for each entity.
If you need/want a single querying point, create a view that unions those individual tables. You can use an EntityType/EntityTypeID...
February 20, 2024 at 2:07 pm
DDL Triggers have a "RENAME" EventType.
If you want to catch it after the fact using some kind of comparison, then you're probably looking for columns that have the same data...
February 19, 2024 at 7:24 pm
Duplicate due to slow response/double click
February 15, 2024 at 5:46 pm
February 14, 2024 at 8:47 pm
February 14, 2024 at 8:46 pm
In general, it's better to avoid nesting views -- so for your case, make the view you want from the two base tables.
Why?
February 13, 2024 at 2:10 pm
NOT IN -- i.e.,
server_principal_name NOT IN (N'mydomain\!sqlmonitoring',N'myDomain\myServiceAccount')
February 7, 2024 at 7:12 pm
Are there concerns about PII? Does data need to be anonymized?
January 31, 2024 at 5:38 pm
How long do backup & restore take?
Are one or both environments virtualized?
Are they on same LAN? Have disk and network health & performance been tested? Results? What is I/O locally...
January 31, 2024 at 5:35 pm
It sounds like you're trying to reinvent sequence or identity. Why not just use a sequence?
January 23, 2024 at 2:22 pm
Viewing 15 posts - 16 through 30 (of 690 total)