Useful tips for everyday
Can join have duplicates? The answer is yes, if there are any. If there are duplicate keys in the tables being joined. How do you…
What is consistent prefix? Consistent prefix consistency level guarantees that reads never see out-of-order writes. Consistent Prefix provides write latencies, availability, and read throughput comparable…
What happens when you insert into a partitioned table? During direct-path INSERT, the database obtains exclusive locks on the table (or on all partitions of…
Can two tables have two relationships? EDIT: Yes, of course there can be two relationships between the same two tables. “there can be two relationships…
Can a SQL Server Backup be used to restore data? A copy of data that can be used to restore and recover the data after…
How to enable force encryption in SQL Server? Right click Protocols for MSSQLSERVER, select Properties and within the Flags tab enable the Force Encryption option.…
How to use invoke-SQLCMD ( sqlServer ) in PowerShell? This command uses Set-Location to navigate to the SQL ServerWindows PowerShell provider path for an instance…
Is the variable categorical or continuous? Categorical variables are those that have discrete categories or levels. Categorical variables can be further defined as nominal, dichotomous,…
What is OLE DB or ODBC error? RE: Data refresh failure – OLE DB or ODBC Error This error generally is for when the data…
What does Replacement mean in probability? Probability with Replacement is used for questions where the outcomes are returned back to the sample space again. Which…