Viewing 15 posts - 9,646 through 9,660 (of 49,552 total)
yuvipoy (3/17/2014)
Not exists vs Not in.The id field in both the table is not null column.
No difference.
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
March 17, 2014 at 6:40 am
If it's 99% empty, then that suggests that the log backups are successfully truncating the log. If they weren't, your log would be a lot fuller. Truncate means 'mark log...
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
March 17, 2014 at 6:39 am
The automatically created stats are ones which the Query Optimiser requests be created to help it generate optimal execution plans. Keeping them updated is as important or more important than...
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
March 17, 2014 at 5:56 am
djj (3/17/2014)
where name not like '_W%'
Why are you explicitly excluding the automatically created statistics?
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
March 17, 2014 at 5:34 am
Restore it as another database, copy the data over.
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
March 16, 2014 at 3:30 pm
I have two clients where I'm writing up a performance report which includes an entire section on their use of NoLock. Going to be an interesting week
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
March 16, 2014 at 2:36 pm
Jpotucek (3/16/2014)
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
March 16, 2014 at 2:33 pm
Jpotucek (3/16/2014)
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
March 16, 2014 at 8:22 am
No, he means there isn't a memory leak. Linked servers use a lot of memory, but that's not the same as a memory leak.
There are a lot of ways 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
March 16, 2014 at 4:31 am
rraza (3/15/2014)
I think we will restore the file backup of that time when table was deleted.
Why a file restore? What's your justification for choosing that type of restore operation? Do...
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
March 16, 2014 at 4:28 am
Testing in Production. Excellent idea! </sarcasm>
You don't have to move any database. Whether or not you move TempDB depends on why you're moving the other databases.
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
March 15, 2014 at 12:24 pm
ALTER DATABASE with the WITH MOVE clause
Take the database offline
Copy the files to their new location
Bring the DB online.
Test in a dev/test environment first.
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
March 15, 2014 at 9:26 am
TST, hard to say anything definitive without a lot more data, but if SQL doesn't need more than 32GB it won't necessarily allocate more.
Check that nothing else on the...
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
March 15, 2014 at 8:25 am
kshaileshbca (3/15/2014)
if you have installed windows on 32-bit platform, SQL consume max 32 GB.
You might want to check your facts....
The memory limit on 32 bit is, in fact 2GB...
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
March 15, 2014 at 8:22 am
Wow, the things you learn around here.
If you check index fragmentation, enable locked pages and enable (but don't configure) resource governor, SQL will magically start to use less memory
http://www.sqlservercentral.com/Forums/FindPost1551457.aspx
and the...
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
March 15, 2014 at 8:19 am
Viewing 15 posts - 9,646 through 9,660 (of 49,552 total)