SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents,...
2014-01-07
1,954 reads
Blog Posts
SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents, gaining access to this data is an on-going challenge...
2014-01-07
42 reads
SQL Server 2014 In-Memory OLTP (Hekaton) Limitations
One of the biggest new features in SQL Server 2014 is SQL Server In-Memory OLTP, known mostly by its code...
2014-01-07
4,179 reads
What’s the Best Path to Becoming a DBA?
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2014-01-07
1,591 reads
What’s the Best Path to Becoming a DBA?
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only...
2014-01-07
28 reads
Why Transaction Log Auto Growths are degrading your performance
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-07
2,867 reads
Answer - Objective Question (Which table is called Heap table in SQL Server)
Question:-
Which table is called Heap table in SQL Server.
1) Table without any indexes
2) Table without any clustered index (Correct...
2014-01-06
643 reads
Are CHECKSUMs being performed with a Compressed Backup?
Now, why in the world would I be asking a question like this?
Well, in BOL (BACKUP) is this little blurb:
CHECKSUM
Specifies...
2014-01-06 (first published: 2013-12-30)
2,904 reads
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-06
26 reads
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-06
640 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas 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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers