Viewing 15 posts - 21,331 through 21,345 (of 49,552 total)
yo_jain (1/5/2012)
I have a very...
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
January 5, 2012 at 4:00 am
ajsnyman (1/5/2012)
Hi All,Hope someone else can confirm this, but it seems like db_datareader db role do not just provide select permissions, but also alter and update permissions.
It does not. db_datareader...
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
January 5, 2012 at 2:54 am
kumar.sachu08 (1/5/2012)
I can't ask from interviewer :Why would you want more than one index on the same column?
Sure you can, and if anyone asked me such a downright silly question...
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
January 5, 2012 at 2:52 am
kumar.sachu08 (1/5/2012)
How many nonclustered index we can implement on one column like "id" as per my below given table structure.
249 in SQL 2005. The question is, why on earth would...
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
January 5, 2012 at 2:51 am
Is there a question here?
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
January 5, 2012 at 2:03 am
Yes, you absolutely can. You can have clustered unique constraints, clustered normal indexes, nonclustered primary keys. There's nothing requiring the cluster to be on the primary key.
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
January 5, 2012 at 1:59 am
Ninja's_RGR'us (1/4/2012)
GilaMonster (1/4/2012)
Ok, talk about deja vu....Deadlocks 1: http://www.sqlservercentral.com/Forums/Topic1229544-1550-1.aspx
Deadlocks 2: http://www.sqlservercentral.com/Forums/Topic1230105-391-1.aspx
Same cause (well, almost), same pattern, same day.
That could be your next article. Comes up often enough that it'll...
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
January 5, 2012 at 1:56 am
captcooldaddy (1/4/2012)
So how do i unhash it?
You don't that the whole point.
The encryption algorithms are nondeterministic, you encrypt a value 3 different times and you get 3 different results. Hence,...
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
January 4, 2012 at 2:40 pm
I'm fully in agreement it shouldn't be plain text, but encrypted is also not good for passwords (especially if using the database encryption which any db_owner or sysadmin can decrypt)....
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
January 4, 2012 at 2:27 pm
No indexes other than the primary key?
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
January 4, 2012 at 2:25 pm
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
January 4, 2012 at 2:24 pm
Ok, talk about deja vu....
Deadlocks 1: http://www.sqlservercentral.com/Forums/Topic1229544-1550-1.aspx
Deadlocks 2: http://www.sqlservercentral.com/Forums/Topic1230105-391-1.aspx
Same cause (well, almost), same pattern, same day.
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
January 4, 2012 at 2:20 pm
emil 94400 (1/4/2012)
The only disappointed with exam was question related to SSIS deployment. I really don't like questions that says <snip>.
Please note that any discussion of the questions in 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
January 4, 2012 at 2:15 pm
Can you post the definition of the SMSJob table and any indexes, constraints or triggers
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
January 4, 2012 at 2:12 pm
Michael Valentine Jones (1/4/2012)
You need to investigate why the spplicaiton is setting that isolation level, and fix that.
I believe ADO.NET (and by extension entitiy framework) does it by default.
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
January 4, 2012 at 2:11 pm
Viewing 15 posts - 21,331 through 21,345 (of 49,552 total)