XP_CmdShell isn’t Evil
Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...
2016-04-14 (first published: 2016-04-09)
1,774 reads
Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...
2016-04-14 (first published: 2016-04-09)
1,774 reads
A few months back I came across an instance of using VI Editor. Trust me being a SQL DBA it...
2016-04-09
5,186 reads
A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...
2016-04-08
742 reads
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
573 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage?
Code coverage is a way to see how...
2016-04-13 (first published: 2016-04-08)
4,449 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
50 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
60 reads
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see how many statements in your database code have been...
2016-04-08
15 reads
The dropDatabase command drops the current database, deleting the associated data files.
Different methods to drop database
Method 1:
1. select the database...
2016-04-08
490 reads
In my previous blog we saw the Full-Text Index architecture.
http://sqlandmorewithkruti.blogspot.in/2016/04/all-about-searching-full-text-indexes_7.html
In this blog we shall see its implementation. Before you proceed...
2016-04-13 (first published: 2016-04-08)
2,654 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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