Reputation
2,183
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
8 29
Newest
 Yearling
Impact
~122k people reached

Sep
18
comment Help required with query (join) optimization
What datatype are you passing into that function? DATETIME?
Sep
14
answered How to uniquely identify SQL instance
Sep
14
revised How to design SQL schema that treats historical data as first-class citizen?
edited body; edited tags
Sep
11
comment SQL Server - comparing PageSplits/sec with Batch Requests/Sec
OK, so Avg BatchRequests/Sec is 217.431 and avg PageSplits/sec is 182.274. That would make PageSplits about 85% of BatchRequests, so according to the article, that could be too high. (it really depends on the situation though)
Sep
11
comment SQL Server - comparing PageSplits/sec with Batch Requests/Sec
Ah, right, I missed the third perfmon. hang on...
Sep
11
comment How to restrict table access to a application
How is the application being authorized to/getting access to SQL Server?
Sep
11
comment SQL Server - comparing PageSplits/sec with Batch Requests/Sec
The article was talking about average values over some period of time. Perfmon graphs instantaneous values. The average over time for a metric is shown in the numeric boxes below the graphs. We can see that it's 0.082 for the Page Splits, but we cannot see what the value is for BatchRequests in you screenshot (you have to select it).
Sep
9
comment Why is removing the Identity property on a column not supported
I have to admit, for some reason I thought that ..SWITCH.. only worked for tables that had at least one partition defined.
Aug
31
comment Remote access to SQL Server 2008 R2 on Windows Server 2012 R2?
Also, have you tried restarting the instance and/or server?
Aug
31
comment Remote access to SQL Server 2008 R2 on Windows Server 2012 R2?
In "ip\instanceName" is "ip" the server name or it's IP address?
Aug
31
comment What does the FullAccess. infront of table mean in SQL Server query?
ReceivedClaimFact could also be a View or Synonym in the FullAccess schema.
Aug
27
comment SQL SERVER 2014 windows administrator locked and sa password lost
1) does the windows server administrator have sys admins on the SQL server? 2) is there anything else on the server? 3) can your domain admin get in or get admins on the server?
Aug
27
awarded  Custodian
Aug
27
reviewed Approve SQL SERVER 2014 windows administrator locked and sa password lost
Aug
4
awarded  Caucus
Aug
4
awarded  Constituent
Jul
20
awarded  Popular Question
Jul
11
awarded  Notable Question
Jun
19
awarded  Curious
Jun
18
comment Fixing a corrupt Log File in small downtime window
Weird. I just got a badge for 2500+ views of this question, yet it has never received any votes, Up or Down. I'm not complaining mind you, just seems odd...