Reputation
2,141
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
7 29
Impact
~111k people reached

Nov
9
comment DDL trigger permission Error
What does "Now M trying to create a table through user2" mean? Be specific and give examples.
Nov
9
comment How to automatically shrink a SQL Server transaction log only if it exceeds a certain limit (e.g. 20 GB)
When you shrink or truncate your Log file, you are breaking your Log recovery chain. This means that any Log backups taken after that point are no good until your next FULL backup. I strongly urge you to find another solution to your problem.
Nov
9
comment How can I get individual rowcounts like SSMS?
I have tried this and it does work for me. Oddly, the StatementCompletions and the InfoMessages from PRINT statements in the stored procedures don't seem to be synchronized wrt each other (I get a bunch of StatementCompletions, then a bunch of PRINT statement outputs, though they are supposed to be interleaved) But I guess that's an SSMS trick for another day...
Oct
27
accepted How can I get individual rowcounts like SSMS?
Oct
27
revised How can I get individual rowcounts like SSMS?
spelling
Oct
27
comment How can I get individual rowcounts like SSMS?
If you had read my question, you would have seen that I am already doing that. It is not in there.
Oct
27
revised How can I get individual rowcounts like SSMS?
added 399 characters in body
Oct
27
comment How can I get individual rowcounts like SSMS?
I cannot modify these procedures. I can modify the client code, including using something other than ExecuteNonQuery.
Oct
27
asked How can I get individual rowcounts like SSMS?
Sep
24
awarded  Self-Learner
Sep
18
comment Help required with query (join) optimization
The function is 90% likely to be the problem here. You should convert it to an inline table-valued function and also declare it to only receive a specific datatype for its parameter.
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?