Viewing 15 posts - 3,361 through 3,375 (of 6,035 total)
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
I was reading a post from someone recently where they noted that they didn't worry to much about the architecture of the system since it wouldn't likely last very long....
October 2, 2015 at 7:11 am
It sounds like you're dealing with a file that has multiple record types. I can't think of any better explanation for a CSV file with a variable number of columns....
October 1, 2015 at 2:56 pm
Steve Jones - SSC Editor (10/1/2015)
October 1, 2015 at 1:42 pm
Viewing 15 posts - 3,361 through 3,375 (of 6,035 total)