Viewing 15 posts - 136 through 150 (of 455 total)
Hugo Kornelis (8/13/2015)
Mighty (8/11/2015)
Toreador (8/11/2015)
"however, you have to append in increments with each increment less than or equal to 4000"Not true.
+1
Not sure where that assumption is coming from. Seems incorrect...
August 14, 2015 at 6:56 am
Thanks for this series!
I was recently handed the specs for twenty-five separate flat files and told to build a process to import them into our data warehouse.
Because of this...
August 12, 2015 at 6:16 am
I ran into this recently while trying to generate a large number of stored procedures with a common format. Simple workaround:
DECLARE @Offset INT = 1;
WHILE LEN(@SQL) >= @Offset
BEGIN
...
August 11, 2015 at 6:16 am
Here's a thought... If this is a table which needs to support a large number of concurrent writes as quickly as possible, why was one option not a memory-optimized OLTP...
August 7, 2015 at 11:41 pm
DrKiller (8/6/2015)
I was looking at the size of the CHAR value... I figured that because it is lower, it'll...
August 6, 2015 at 6:26 am
Interesting. I recently had to implement row-level security on a reporting where access could be granted in three distinct ways.
Since all access to the reporting system is via stored...
July 29, 2015 at 7:44 am
vdkolekar (7/21/2015)
Tricky questionSorry I didn't understand it clearly.
Why both of below queries give Null Values.
DECLARE @a INT=0;
DECLARE @b INT=0;
SET @a = (select 1 where 1=2);
The subquery here returns an empty...
July 25, 2015 at 6:52 pm
Simon Jackson (7/14/2015)
If I replace the SET with SELECT , I get the same result.
Just from experimenting, it seems to...
July 14, 2015 at 5:39 am
TomThomson (6/29/2015)
June 29, 2015 at 7:14 am
eric.notheisen (5/26/2015)
May 26, 2015 at 11:51 am
From where can a global cursor be accessed?
From the unemployment line when it's discovered you're still using cursors, and global ones at that, in this day and age.
😛
May 22, 2015 at 11:14 am
Great. Now I'm trying to conceive of a situation where one would want to use PIVOT within a recursive CTE... :blink:
April 21, 2015 at 7:27 am
John Mitchell-245523 (4/10/2015)
Richard Warr (4/10/2015)
Where it says "116 characters or less" it means "116 characters or fewer" 😉
I would argue that either is correct. If you interpret "116 characters"...
April 10, 2015 at 9:19 am
TomThomson (3/30/2015)
sknox (3/30/2015)
ZZartin (3/30/2015)
March 31, 2015 at 11:00 am
ZZartin (3/30/2015)
Let's be honest requiring statement terminators is to make life easier on the developers writing the syntax parser not because there is any inherent value in a ;
That is...
March 30, 2015 at 4:35 pm
Viewing 15 posts - 136 through 150 (of 455 total)