Viewing 15 posts - 28,741 through 28,755 (of 49,552 total)
Started a transaction, took locks, didn't commit or roll back.
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
December 29, 2010 at 7:01 am
You can use join hints for both.
Create Table T1 (
SomeVal int
)
Create table T2 (
SomeVal int
)
insert into T1 values (1),(2)
insert into T2 values (1),(3)
GO
SELECT * FROM T1
WHERE NOT...
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
December 29, 2010 at 6:56 am
I am really struggling for inspiration for a 24hop abstract. Would a session title 'Bad plan! Sit!' intrigue people, or kill them with laughter?
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
December 29, 2010 at 6:49 am
WayneS (12/28/2010)
Just to ensure that I understand this correctly: if you explicitly add the CI column(s), they won't also be implicitly added?
The columns just need to be there, it doesn't...
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
December 29, 2010 at 2:29 am
saidapur_satish (12/29/2010)
User login one server to another server..... How do i do?
Server-level login or database-level user? Which one?
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
December 29, 2010 at 2:21 am
It's not the size of the database that's important, it's the activity of the DB. 400 mostly idle databases are totally different from 400 very heavily used databases. The hardware...
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
December 28, 2010 at 10:58 am
Column encryption and database encryption are completely different things, with different purposes.
Column encryption protects against unauthorised people querying the data
Database encryption protects the database files and backups from being copied...
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
December 28, 2010 at 10:55 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1039709-364-1.aspx
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
December 28, 2010 at 7:47 am
ananda.murugesan (12/28/2010)
For restore first full backup with no recovery then apply all differential backup day wise.
Apply last differential, not all of them.
Please give me differntial backup script ( for user...
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
December 28, 2010 at 7:38 am
S_Kumar_S (12/28/2010)
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
December 28, 2010 at 7:36 am
S_Kumar_S (12/27/2010)
So is it okay to drop Col1 from non clustered index?
You can, but bear in mind that should the cluster be changed at some point in the future,...
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
December 28, 2010 at 3:09 am
Michael Valentine Jones (12/27/2010)
Does he post on SSC or some other web sites?
Haven't seen him here, not in name or attitude.
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
December 27, 2010 at 10:33 am
The skills measured is listed here: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us
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
December 27, 2010 at 3:00 am
User info or login info?
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
December 26, 2010 at 1:01 pm
saidapur_satish (12/26/2010)
Thanks, but i am not get properly could you explain me main things commonly what DBA will do?
How much experience do you have as a DBA and what position...
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
December 26, 2010 at 1:01 pm
Viewing 15 posts - 28,741 through 28,755 (of 49,552 total)