Can I tune the tempDB of an Azure based SQL Server database…
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
397 reads
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
397 reads
Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...
2017-04-01
410 reads
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
385 reads
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a...
2017-04-01
1,641 reads
Each year I try to something fun for April 1st, though it’s hard to do well. Trying to be funny...
2017-04-01
517 reads
From time to time we all have to examine our path and decide if we need to make adjustments. Looking...
2017-04-01
431 reads
SQL Saturday conferences are awesome.
That is the opening line of this blog post – because it’s true and understated.
If you’re reading...
2017-04-01
248 reads
Apr 1st 2.45 pm, I will be presenting “Re-Indexing – The quest of ultimate automation” @ sqlsaturday, Orange County, if you are...
2017-03-31
586 reads
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,537 reads
Recently the PASS Blog released some changes to the speaker selection process that have generated some commentary and thoughts from...
2017-03-31
818 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