Viewing 15 posts - 5,176 through 5,190 (of 8,761 total)
Quick thought, you can change the select to a delete and delete from the cte directly.
😎
May 28, 2015 at 10:27 am
Quick thought, how about using Extended Events and capture OPEN SYMMETRIC KEY, surely those columns are encrypted?
😎
May 28, 2015 at 10:22 am
crookj (5/27/2015)
DonlSimpson (5/27/2015)
Ed Wagner (5/27/2015)
djj (5/27/2015)
LavaErupt
Anger
Management
Therapy
May 28, 2015 at 12:55 am
ma701ss (5/27/2015)
I have two columns in an Excel spreadsheet: productid and colour.
These columns are populated with values, e.g. '123' and 'Red'.
I have about 200 rows and want to insert the...
May 27, 2015 at 10:24 pm
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree" are antithetical to...
May 27, 2015 at 12:14 pm
Eric M Russell (5/27/2015)
May 27, 2015 at 11:52 am
My 2 cents on the security and privileges: for the production data, developers with administrative privileges are more dangerous than high heel wing walking on a fighter jet, cannot recall...
May 27, 2015 at 11:29 am
Grant Fritchey (5/27/2015)
You really can frequently figure out how to get your job done without zero security.
+1
😎
BTW, think this experiment thread is becoming a proof that digression is somewhat of...
May 27, 2015 at 11:19 am
crookj (5/26/2015)
Ed Wagner (5/26/2015)
Eirikur Eiriksson (5/22/2015)
Revenant (5/22/2015)
SQLRNNR (5/22/2015)
psychoacousticaudio
noise
Background
Image
Spitting
May 26, 2015 at 6:52 am
Jim1234 (5/25/2015)
When I'm trying to connect to a tabular cube via Power Pivot in Excel 2010, I'm getting an error
"The following system error occurred: A connection attempt failed because the...
May 25, 2015 at 4:10 pm
adam.mesny (5/25/2015)
May 25, 2015 at 3:42 pm
Jason A. Long (5/25/2015)
Windowed functions are an extremely powerful feature, and...
May 25, 2015 at 3:33 pm
Quick single scan solution
😎
USE tempdb;
GO
SET NOCOUNT ON;
WITH XSAMPLE(book, position) AS
(SELECT * FROM (VALUES
('A', 500)
,('B',-500)
,('C',-500)
) AS X(book,...
May 25, 2015 at 3:32 pm
simon.harvey 41170 (5/25/2015)
There could be a whole lot of hidden costs as in rewriting stuff that no longer works.
Too true - I got the impression that even the SAAS costs...
May 25, 2015 at 3:03 pm
TheSQLGuru (5/25/2015)
Eirikur Eiriksson (5/23/2015)
TheSQLGuru (5/23/2015)
This thread has become a laundry list of worst practices!! 🙂That by itself presents an opportunity, care to do a write up?
😎
Nope, sorry. I don't like...
May 25, 2015 at 2:43 pm
Viewing 15 posts - 5,176 through 5,190 (of 8,761 total)