ALTER SCHEMA
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,864 reads
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server...
2011-10-24
1,864 reads
When completing an installation I saw the following error – which stopped the installation .
The error occurred during the creation of...
2011-10-24
1,892 reads
1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL...
2011-10-19
1,445 reads
Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
--To find...
2011-10-18
527 reads
SQL Server Books online defines the OLEDB wait stat type as “Occurs when SQL Server calls the SQL Server Native...
2011-10-15
6,232 reads
sys.dm_os_loaded_modules is a SQL Server OS Dynamic Management View (DMV).
When executing the t-sql statement below – a recordset is returned . I’ve...
2011-10-10
2,292 reads
Instead of using DBCC CHECKDB , which checks on consistency and allocation across the whole database, an alternative is DBCC CHECKTABLE...
2011-10-08
2,681 reads
On Windows 2003 Enterprise Edition Service Pack 2 TCP Chimney was enabled by default. It took me a while to...
2011-10-04
1,233 reads
According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged....
2011-10-03
1,185 reads
Managing large SQL Server inventories requires standardisation. Do your research , create the scripts , and apply.
Occasionally, custom changes are required . This...
2011-09-28
3,971 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers