How to find out whether your database is transactional, analytical or hybrid?
If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...
2018-04-26
378 reads
If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...
2018-04-26
378 reads
SELECT * FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v;
2018-04-23
315 reads
2018-04-20
WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...
2018-04-20
10,843 reads
USE master
exec sp_MSforeachdb '
use [?]
print ''?''
print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200))
if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE ''
dbcc shrinkfile(2,1)
'
2018-04-20
296 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
406 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
9,286 reads
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
1,473 reads
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
12,209 reads
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
532 reads
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
I took a backup with the CHECKSUM option, which was successful and showed no...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers