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,863 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,863 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
526 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,290 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,184 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,968 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Contact us via WhatsApp:+971 58 250 2196 Contact us via WhatsApp:+971 58 250 2196...
Contact us via WhatsApp: 000971582502196 Contact us via WhatsApp: 000971582502196 Contact us via WhatsApp:...
Contact us via WhatsApp: 000971582502196 Contact us via WhatsApp: 000971582502196 Contact us via WhatsApp:...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers