SQL Server – sys.master_files and list all database files
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,463 reads
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,463 reads
Somewhat overshadowed, for obvious reasons, by the big RTM release of SQL Server 2012 was the RTM release of PowerPivot...
2012-03-07
1,194 reads
In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...
2012-03-06
888 reads
Originally published March 6, now with Post-launch updates.
Just a quick note for you today: Microsoft announced that SQL Server 2012...
2012-03-06
1,001 reads
I had an exchange with someone that had plagiarized some work recently. That’s nothing new, and I run into plagiarism...
2012-03-06
1,212 reads
2012-03-06
1,441 reads
Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing (RTM). Customers and partners can download an...
2012-03-06
1,656 reads
So it looks like today is the day.
SQL Server 2012 has been RTM’d today.
General Release 1st April 2012
http://www.microsoft.com/Presspass/press/2012/mar12/03-06SQLServer12PR.mspx
2012-03-06
2,051 reads
This week I had an application team report the error “SQL Connection Lost”. Fortunately they also reported the exact times...
2012-03-06
1,705 reads
I asked a few questions on twitter this morning after a friend of mine said they were have problems downloading...
2012-03-06
789 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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