Viewing 15 posts - 14,971 through 14,985 (of 49,552 total)
SQLCrazyCertified (1/4/2013)
You mentioned that SQL using all of it's memory which is allocated to it is a normal behavior, if this is true, when does the SQL release the memory?
When...
January 5, 2013 at 1:46 am
CELKO (1/4/2013)
3) Why would you have a design so bad that you need dynamic SQL? Are data element names changing at run time? Is the name of the procedure “No_Idea_What_I_Am...
January 4, 2013 at 3:35 pm
rightfield (1/4/2013)
January 4, 2013 at 2:37 pm
lsalih (1/4/2013)
you mentioned that by just rebuilding the indexes, that should help...
I never said, suggested or implied that index rebuild would shrink a database file. I said that index rebuilds...
January 4, 2013 at 2:30 pm
Better, no. Easier, yes.
Shrinkdatabase gives you no control over the free space left in each file, just in the DB as a whole, plus it shrinks the log file...
January 4, 2013 at 2:29 pm
DBCC ShrinkFile on each file. Once you've done that, rebuild all indexes. Don't shrink as small as possible, leave some free space in the files
January 4, 2013 at 1:56 pm
You can. The cert's aimed at people with 2-3 years of experience though.
I'd start by asking your boss what resources he's willing to provide for you to learn SQL, since...
January 4, 2013 at 9:26 am
It could be anything. Shotgun tuning however won't help.
Chapter 1: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Identify the problem, then consider what the potential solution is.
January 4, 2013 at 9:24 am
wolfkillj (1/4/2013)
IIRC, SQL Server can auto-parameterize a dynamic T-SQL query and cache the execution plan like any other.
It'll always cache the plan, parameterised or not. Only very simple queries (no...
January 4, 2013 at 7:51 am
Terrie (1/4/2013)
So a shrink with no_truncate would improve performance?
No.
No, a shrink (even a 'properly performed' one) will not improve SQL performance. The index rebuild and stats update they recommend would...
January 4, 2013 at 6:54 am
Please post new questions in a new thread. Thanks
LOB data makes shrinks very slow, as does heaps. Shrink in smaller chunks, not all at once.
January 4, 2013 at 5:58 am
Shadab Shah (1/4/2013)
Now what about the column other than the clustered index. They too might have fragmentation. Does this means Table Fragmentation.
No. Fragmentation is something that indexes have, not tables.
Fragmentation...
January 4, 2013 at 5:21 am
devanandiiway (1/4/2013)
Do you mean that I need to move all the mdf from that drive?
Unless you are happy that the databases on there may potentially become corrupted, yes. That's like...
January 4, 2013 at 5:12 am
SQLCrazyCertified (1/3/2013)
We have some performance issue..SQL server is running very slow due to high memory usage.
Are you sure that high memory usage is causing SQL to run slow? Cause, not...
January 4, 2013 at 2:24 am
Ramdas Baghel (1/3/2013)
January 4, 2013 at 2:20 am
Viewing 15 posts - 14,971 through 14,985 (of 49,552 total)