SQL Table variable and temporary table
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage...
2011-12-01
1,765 reads
The process could not read file due to OS error 3
When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:
The process...
2011-11-30
43,351 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL...
2011-11-30
15 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out...
2011-11-30
1,636 reads
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,335 reads
Using OFFSET and FETCH
Introduction
Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list...
2011-11-30
9,810 reads
Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,659 reads
Forgiving Mistakes
My main phone line at the house has been on the fritz for about 3-4 weeks. Yes, we still have...
2011-11-30
2,440 reads
Convince me to read books (WHERE LEN(argument)
While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...
2011-11-30
1,680 reads
DBA in Space: Behind the Scenes—Question 8
Part 1 of Question 8—The question.Part 2 of Question 8—The follow up to the question.This is a continuation of my...
2011-11-30
1,862 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Mangunsarkoro Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
Alamat BCA KCU CIANJUR Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers