On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll explain about that later in this post. This should...
2012-12-20
14 reads
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll explain about that later in this post. This should...
2012-12-20
14 reads
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll...
2012-12-20
1,569 reads
I hadn’t used full-text indexing in production throughout my career. We hadn’t had the need in the applications I worked...
2012-12-31 (first published: 2012-12-19)
4,010 reads
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...
2012-12-19
852 reads
You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create...
2012-12-28 (first published: 2012-12-19)
4,142 reads
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed...
2012-12-27 (first published: 2012-12-19)
2,123 reads
So far this series has been a bit of fun. We have discussed a fair amount of useful things to date. And here we are only on the seventh...
2012-12-19
17 reads
So far this series has been a bit of fun. We have discussed a fair amount of useful things to...
2012-12-19
1,438 reads
As we approach a new year many of you will be looking at your SQL Server Training needs for 2013....
2012-12-19
776 reads
Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...
2012-12-19
50,551 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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