Derived Table In Sql Server
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,013 reads
Blog Posts
Massively Parallel Processing and the Parallel Data Warehouse
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,808 reads
New road to the SQL Server 2012 Certifications
MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old...
2012-04-14
2,079 reads
Pivot and Unpivot table in SQL SERVER
Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means...
2012-04-14
39,600 reads
So I started this blog…now what?
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
576 reads
Tech Days Albania 2012
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,845 reads
A Tale of Four Laptops
With the release of the 22nm Ivy Bridge microarchitecture less than three weeks away, at the end of April 2012,...
2012-04-13 (first published: 2012-04-10)
3,208 reads
I am a Linchpin Team Mate
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,020 reads
I am speaking at #sqlsat111 on TEMPDB.
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
580 reads
Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,511 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers