Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which...
2016-03-11
421 reads
StrateSQL
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....
2016-03-11
1 reads
Monday Morning SQL Break – February 22, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-03-11
461 reads
PASS Cloud Virtual Chapter – Call for Presenters
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2016-03-10
361 reads
Monday Morning SQL Break – March 7, 2016
It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL). This...
2016-03-07
251 reads
Monday Morning SQL Break – February 15, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-15
389 reads
Monday Morning SQL Break – February 8, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-08
333 reads
Monday Morning SQL Break – February 1, 2016
It’s Monday and time fora round-up of last week’s blog and twitter activity – and even an on-time post for all of...
2016-02-01
466 reads
Monday Morning SQL Break – January 25, 2016
It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL)....
2016-01-25
384 reads
Monday Morning SQL Break – January 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-01-25
411 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers