Viewing 15 posts - 3,361 through 3,375 (of 6,038 total)
What is the source for the surveys, and what experience level are job postings looking for when they offer $120k? I would expect the average salary offered by prospecting employers...
October 5, 2015 at 1:18 pm
Some of these spam posts are so poorly translated, it's not obvious if they're actually trying sell or promote something, if it's randomly generated gibberish, or if the poster is...
October 5, 2015 at 12:41 pm
I guess "code smells" and "technical debt" are somewhat related.
October 5, 2015 at 12:29 pm
Ideally, each application or user account should be a member of a role, and the only additional permissions for each role should be execution on only the procedures that role...
October 5, 2015 at 10:58 am
It seems to me that, if InformationOverride is meant for exclusion, then you're missing a "WHERE vcf.MeetID IS NULL" clause, or if InformationOverride is meant for inclusion, then it should...
October 5, 2015 at 9:22 am
Perhaps we could have a spam reporting policy that works something like this:
If a trusted user (meaning perhaps a user with a certain level of points of higher) reports...
October 5, 2015 at 8:59 am
From what I've seen, few data breaches are the result of exploiting holes in the database engine itself. The major RDMS are solid in terms of security; and SQL Server...
October 5, 2015 at 8:15 am
Like Gail said, SQL Server rarely throws "out of memory" type exception. If low on memory, it will typically spool to tempdb, or if there are simlultaneous requests, will start...
October 5, 2015 at 7:06 am
898 million page reads? Each page is 8'000 bytes... :w00t:
October 3, 2015 at 6:13 pm
A database originally designed with a de-normalized data model and crappy SQL back in the 90's could easily be lumbering along today as is after having been ported to v2000,...
October 2, 2015 at 11:43 am
alorenzini 26244 (10/2/2015)
Thank you. I have a feeling you will get sick of me before too long.
Believe or not, there are a lot of folks here who actually enjoy answering...
October 2, 2015 at 10:08 am
Run this to get a breakdown of how much memory is allocated to each memory cache, compare page buffer cache (CACHESTORE_OBJCP) to query plan cache (CACHESTORE_SQLCP).
Select [type],SUM([single_pages_kb]) As [single_pages_kb]
,SUM([multi_pages_kb])...
October 2, 2015 at 9:58 am
Read this article. It will tell you for each active session how to get the KB memory requested by running query, actual KB granted, and KB considered ideal by optimizer...
October 2, 2015 at 9:40 am
Hi Art,
Just out of curiosity, is there no one else in your organization who knows a thing about SQL Server, or did the previous DBA pack up and leave? In...
October 2, 2015 at 9:17 am
tauseef.jan (10/2/2015)
SQL Surfer '66 (10/2/2015)
October 2, 2015 at 7:55 am
Viewing 15 posts - 3,361 through 3,375 (of 6,038 total)