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
529 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,234 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,317 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,683 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,234 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,187 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
4,007 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers