Viewing 15 posts - 1 through 15 (of 18 total)
Yes, I think the motivation is to save lines of code. (Its not actually my idea.) The dimension has over 20 columns, most of which are type 2, so it could...
June 6, 2017 at 2:25 pm
Min: 2048 MB.
Max: 6144 MB.
OS: Windows 2012 Standard.
SQL: 2012 Standard.
According to my monitoring tool, SQL total memory (equivalent perfmon counter: SQLServer:Memory Manager - Total Server Memory (KB) ) varies mostly...
April 28, 2015 at 12:14 pm
Very nice! Made the change, now printing the number of rows in calling procedure A produces:
35422
which is the correct value. Thanks!
July 9, 2014 at 11:40 am
Interesting. I was working off of the DMV documentation in Technet, which reads:
Returns information about the queries that have acquired a memory grant or that still require a memory grant...
January 3, 2014 at 10:29 am
Yes, still running an application with a lot of stored procedures with the obsolete join syntax. New system has been developed and is slated to go into production next week!
March 12, 2012 at 9:52 am
Evidence still seems to indicate the copy program (written using SSIS) is instrumental in the corruption, in other words, corruption only occurs when the copy program runs. It is still...
January 12, 2012 at 2:27 pm
I doubt its a hardware issue. Its a virtualized server and no other server on the host is experiencing problems. The storage is on a SAN and again, none of...
June 27, 2011 at 3:54 pm
Its not well known, but a true flying car has been invented.
May 2, 2011 at 3:53 pm
Interesting. Thanks for sharing.
April 26, 2011 at 10:04 am
Sophisticated method: Tape backup systems (the one we use, for example) will work with a purchased agent that can be installed on the SQL Server's server. When the tape backup...
April 25, 2011 at 2:52 pm
Server admins vary. Some of them understand database backups. Others think taking a copy of the .mdf and .ldf files constitutes a backup. Unless Section 3 includes DBAs, you cannot...
March 30, 2011 at 3:42 pm
Thanks. I'm glad you posted your article, its much needed. Over and over again I see OLTP-oriented databases which are installed as Simple which really should be Full.
September 21, 2009 at 9:05 am
I agree that the default recovery model should be Full. However there are cases where the simple model is more appropriate. For example, if its mostly large "batch" jobs that...
September 21, 2009 at 8:35 am
They pay us a lot of money to develop applications, design databases, etc. Once its simple, they will pay someone else a lot less.
June 16, 2009 at 5:31 pm
Help/manuals/discussion groups/Google searches online. In the old days I would sit and read the manual for a couple days. Now I can come up to speed in a couple of...
March 20, 2009 at 2:46 pm
Viewing 15 posts - 1 through 15 (of 18 total)