SQL server logs - I have a question about SQL server logs and SQL server error logs. What usually are logged, I can see...
Pitfalls of cross-database views? - Hi, I currently work for myself and provide IT services to a hedge fund with around ~30 traders and analysts who...
SSMS Ctrl+U Shortcut - For as long as I can remember, Ctrl+U takes you to the list of databases on the server, allowing you...
SQL Account - Once the SQL Server gets built by someone, later i would like to get notified about new database creations(this would...
Permissions for different AD Groups - HI, I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins....
How can I offload the compute of SUM operation ? - Hi, I have an interesting case. I have SQL resources governor configured with two different type of workloads : batch and users. Batch...
Subqueries examples - Someone new to SQL asked me to show him a dozen of subqueries samples for Northwind or AdventureWorks databases. Does...
Mirroring - I have database mirroring configured from Server A(principal) to Server C(mirror). However, i am thinking to do another DB mirroring...
insert to .XLSX fails if len(column) > 255 - Error: ERROR MESSAGE: String orbinary data would be trun
Varchar(Max) storage - Dear Experts, Have a confusion regards to the storage capacity of varchar(max). My question is , when 8000 bytes (the whole page)...
Clustering - I have N-Way clustering setup and i need to configure the DR solution for the database located in the SQL...
Can't connect to the reporting services from SSMS - Hi, I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create...
Joining a result set to a base table - I have a weird one that is hard to explain. So I am looking for any Providers that are not listed...
trimming SSNs - I have thousands of social security numbers I need to trim to leave only the last 4 digits... it is...
Database suspect during backup but not actually in a suspect state - Hi folks, This morning I noticed one of my DIFF backups jobs failed. (I'm using Ola's scripts) Problem is when I...
Filtering by date crashes report\query - Hi, I have the following sql query SELECT DISTINCT scheme.ABC.users_text_field, scheme.efg.PAL_efg, scheme.efg.PAL_oqty, scheme.efg.PAL_product, scheme.efg.PAL_date, &nb
Delete duplicate rows from ANY table. - Is there is 'fairly' simple query to delete duplicate rows from ANY table ? A script which removes duplicates from a...
Sql Query to find invalid SSN Numbers - I would like to write a query that returns any Employees (id, ssn, and name) with an invalid SSN along...
Restore the .Trn files from the directory folder - Hello Experts ! with the help of below topic https://www.sqlservercentral.com/Forums/Topic1817731-3412-1.aspx I tired to some modification the below script which is posted having...
skip function if completed successfully - I have a function where I'm executing in succession a list of sql queries\updates. The function has try\catch so if...
