Instant File Initialization Security Risk
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
964 reads
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
964 reads
While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...
2012-04-16
932 reads
In my professional development presentation, I list the "soft skills" books that I have found most helpful in my career to date. You can find...
2012-04-16
1,594 reads
TweetG’day,
On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.
The day was run by Dave Curlewis [Blog...
2012-04-16
1,118 reads
Data growth is related to Moore’s law. As computers get faster and more powerful, we are using them to process...
2012-04-15
7,833 reads
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In...
2012-04-15
1,442 reads
Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It is...
2012-04-15
18,030 reads
MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old...
2012-04-14
2,087 reads
I’m very excited for the invitation to present at TechDays Albania 2012, which will be held on April 19, 2012...
2012-04-14
1,859 reads
Date: May 19, 2012
Location: SQLSaturday #119, Chicago
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve started a blog...
2012-04-14
579 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. I...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers