Viewing 15 posts - 1,561 through 1,575 (of 5,843 total)
I came across one person that had substantial problems with row-by-row processing on SQL 2012. I am severely jet-lagged at the moment so I can't remember the details, and could...
April 15, 2015 at 10:33 am
Bill I think your example, while slick, doesn't meet the OPs needs, which it to have all time buckets, even if they don't have matching records.
April 8, 2015 at 10:53 am
Looks reasonable, Alan, but I think you need 2 changes:
1) The OP wanted 15 minute "buckets". Easy change obviously.
2) I would want to add in a GROUP BY clause because...
April 8, 2015 at 9:45 am
I note that this piece of information "clientapp="SQLDEPLOY"" could mean that the devs really DON'T know what is going on under the covers if they have some automated thingy doing...
April 8, 2015 at 7:25 am
There are SOOOOOO many things that come into play with Always On that it isn't even funny. Most people don't have ANY clue what they are getting into or...
March 31, 2015 at 8:55 am
I will add that you really REALLY don't want a CURSOR in a UDF.
March 30, 2015 at 12:43 pm
Jako de Wet (3/27/2015)
Hi KevinDont worry, we have another company that do our server setups, I want to know what direction to send them in.
The only way I know of...
March 27, 2015 at 9:47 am
Jako, I have NEVER heard of someone reading a forum post or blog series, slapping together a windows failover cluster and dropping SQL Server AG(s) on them and have it...
March 27, 2015 at 8:49 am
The root cause of this failure was that you either a) built a cluster that wasn't properly validated/tested from the start or b) you allowed changes to your production environment...
March 27, 2015 at 8:44 am
tdennis-674196 (3/24/2015)
In your reply, the implication (emphasized by me above) is that a GUID has a larger capacity than a bigint. The actual number of unique values of a GUID...
March 24, 2015 at 12:14 pm
Add up the sizes of all the tables (including there indexes) for existing data. Then estimate how many rows/size you will need 12-18 months out and make the database...
March 24, 2015 at 8:44 am
donsjones48 (3/24/2015)
We are experience higher than normal CPU and Memory paging with the patches installed. When we...
March 24, 2015 at 8:25 am
Dropping unused indexes is a GREAT idea - but with a bunch of caveats, provisos, limitations, gotchas, etc. A short list includes:
1) do not drop indexes that ensure something...
March 23, 2015 at 5:27 pm
cbosman0 (3/19/2015)
March 19, 2015 at 5:32 am
rwitt 95744 (3/18/2015)
Thanks for your response.
By functions, I mean table-valued functions (NOT multi-statement table valued functions.) We have a very small number of scalar functions & a very...
March 19, 2015 at 3:47 am
Viewing 15 posts - 1,561 through 1,575 (of 5,843 total)