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
419 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
419 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
343 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
12,343 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
328 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
467 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
12,501 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
8,159 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
15,921 reads
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
615 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers