Viewing 15 posts - 26,491 through 26,505 (of 49,552 total)
LutzM (4/26/2011)
Any advice regarding time management in general?
Yeah, learn how to, from someone who can. I'm terrible at at that. If I could manage time well I'd have finished this...
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
April 26, 2011 at 4:35 pm
M.Sc, not PhD (yet)
I dabble in a lot of stuff, some works out well, some doesn't. It's been several years since I last wrote fiction of any form. Kinda miss...
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
April 26, 2011 at 3:11 pm
Apurva (4/26/2011)
When you restore database to a different server your Database users are orphaned.
Not if when the logins are created they are created with the same SID as 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
April 26, 2011 at 2:49 pm
There's no need to count all the rows just to see if any rows exist. It's inefficient.
IF EXISTS (select 1
from dynamicsgp_utilities.dbo.V_sfvouchers
where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid...
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
April 26, 2011 at 2:09 pm
ColdCoffee (4/26/2011)
I would advice you to use Aliases for the tables and then run the query.. probabaly some outer query is accessing the columns of the inner query..
It's likely this...
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
April 26, 2011 at 1:53 pm
What are you trying to set @cnt 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
April 26, 2011 at 1:49 pm
SQLRNNR (4/26/2011)
Stefan Krzywicki (4/26/2011)
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
That is something that would strongly tempt...
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
April 26, 2011 at 1:42 pm
I don't do epic verse.
Though... (read attached at your own risk, very amateur attempt)
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
April 26, 2011 at 1:30 pm
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
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
April 26, 2011 at 12:47 pm
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/Topic1098821-392-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
April 26, 2011 at 11:14 am
No, read the kb article again. It's not split brain. If you try to query the former principal, you'll get an error.
To have a split brain scenario, both servers...
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
April 26, 2011 at 10:50 am
When you have a numeric, the first number (p) is the total number of digits that can be stored. The second number (s) is how many of those digits are...
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
April 26, 2011 at 10:48 am
Grant Fritchey (4/26/2011)
nico van niekerk (4/26/2011)
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
April 26, 2011 at 8:31 am
Enterprise edition? If so, you should be able to do the rebuild online. If not, you just have to accept the impact from your mistake. It won't lock the entire...
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
April 26, 2011 at 8:09 am
You need to rebuild the index.
Disabling an index drops the entire b-tree, just leaving the metadata behind. It takes a rebuild to recreate that.
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
April 26, 2011 at 7:59 am
Viewing 15 posts - 26,491 through 26,505 (of 49,552 total)