Viewing 15 posts - 9,916 through 9,930 (of 49,552 total)
Tune the query, tune the indexes. Without more information that's about all that can be said.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 7:09 am
I asked on your other thread but got no answer, is your instance case-sensitive?
What's the exact version of SQL Server that you're working with?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 7:07 am
Look in the SQL Server error log, what is the exact message which gets recorded for the login failure?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 5:16 am
'Custom audit' can be as simple as logging information you want to keep for as long as you want to keep it. Start by figuring out what you want to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 5:14 am
Unless you had some custom auditing implemented before that change was made, no way to tell.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 4:19 am
huw.pickrell (2/24/2014)
I was creating the scripts for the table definitions and data,but after simplifying it for this forum, I was getting the result I was expecting.
That happens so often. 🙂
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 4:17 am
For what, creating a temp table? http://technet.microsoft.com/en-us/library/ms174979.aspx Scroll down to the Remarks section and look for the header "Temporary Tables"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 4:17 am
roblew 15918 (2/24/2014)
What would the best way be to test the performance/improvement if any of using a clustered index view?
Same way you test the performance of anything, benchmarks without, benchmarks...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 4:15 am
bugg (2/24/2014)
1) Is it possible to upgrade to 64 bit.
Uninstall. Reinstall.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 4:12 am
Kinda, create a table to store the value and increment/decrement the value as appropriate when the procedure is called. You'll have to watch locking/isolation levels to ensure the correct results...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 3:23 am
It works much like nonclustered index on a table do. When a row in the table is changed, the indexes are updated appropriately. Indexed view gets much the same treatment.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 3:22 am
Could you please post table definitions and some sample data (as insert statements)? See http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 2:56 am
Try changing the permanent table to a temp table, I can't see any valid reason why that script would be creating a permanent table in tempDb instead of just using...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 1:56 am
Restore from backup.
The only time repair rebuild will fix corruption is when the second-last line of the checkDB output reads "REPAIR_REBUILD is the minimum level to repair"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 1:31 am
It has a decimal place, hence it can't convert to int. Try float or numeric/decimal instead.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 24, 2014 at 12:55 am
Viewing 15 posts - 9,916 through 9,930 (of 49,552 total)