Viewing 15 posts - 2,581 through 2,595 (of 3,061 total)
ifila (5/8/2009)Since space is cheap is it better to use nvarchar and forget about it
... depending of the scale that statement might not hold true; imagine you have a 4...
May 8, 2009 at 8:14 am
In the Oracle world roles are usually granted once to an specific user so that user account will inherit all privileges associated with the role each time it logs in...
May 8, 2009 at 8:07 am
It all depends.
If SQL Server 2000 is not needed and there is no database to be upgraded to 2005 just uninstall SS2K and install SS2K5
If SQL Server is still needed...
May 8, 2009 at 8:00 am
raj more (5/7/2009)
I was wondering if it was the Express edition - since it only allows a limited number of active connections.
Not sure how reaching the max number of allowed...
May 7, 2009 at 2:01 pm
For the specific query in the described scenario only two of the tables enter into play: DimDate and FactTransactions; as I can see it there is a 1-to-n relationship in...
May 7, 2009 at 1:20 pm
Igor Makedon (5/7/2009)It looks like Pablo(3:20 PM) was mistaken with his "1." statement.
My fault, I'm sorry.
I was relying on my experience on previous SS versions; looks like SS2K5 has...
May 7, 2009 at 12:43 pm
CREATE ROLE NEWROLE NOT IDENTIFIED
;
GRANT NEWROLE TO USERACCOUNT
;
ALTER USER USERACCOUNT DEFAULT ROLE NEWROLE,
...
May 7, 2009 at 9:16 am
Igor Makedon (5/7/2009)
My question is: "Is it possible and if yes, what needs to be done to hide this score of embarrassing database names from users (many of them) who...
May 7, 2009 at 8:20 am
The more compression you use the more you penalize the backup process in terms of processing -the more compression the more complex the algorithm.
Restore would benefit of reading a small...
May 7, 2009 at 6:52 am
rajdvs28 (5/4/2009)It would be a better idea to partition the database table to accommodate future growth in terms of columns. That means column partitioning so that the data rows are...
May 7, 2009 at 6:47 am
I'll pick Space utilization and Performance; in the last case a chart showing how performance relates to SLA wouldn't hurt and, if good would make you famous among management. Well,...
May 7, 2009 at 6:42 am
Lets pretend I didn't read the part about affected databases not being part of that server.
Is the offending Maintenance Plan set up to backup "All Databases"?
if this is the case...
May 6, 2009 at 3:11 pm
I'm probably missing something in your scenario.
Because of SQL Server security architecture all users have to have a LOGIN entry at the server level then you map that LOGIN entry...
May 6, 2009 at 3:05 pm
Krishna Potlakayala (5/6/2009)[DR is the basic building block of a any online business.
I agree but I would add that doesn't matter if the affected systems are supporting an online business...
May 6, 2009 at 12:42 pm
mmhhh... you can't touch the code and SQL Server does not supports function based indexes; that moves your issue from the "problem" to the "feature" category -most probably you can...
May 6, 2009 at 12:35 pm
Viewing 15 posts - 2,581 through 2,595 (of 3,061 total)