Viewing 15 posts - 7,741 through 7,755 (of 49,552 total)
CREATE PROC usp_get_counts (@tablename VARCHAR(50))
AS
BEGIN
SELECT SUM(row_count) AS RowCount
...
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
September 22, 2014 at 6:31 am
Error messages please. Every single message, plus anything that's in the error logs.
I don't think I've ever seen a case where SQL database files were recovered after deletion and were...
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
September 22, 2014 at 6:24 am
Steps are given here:
http://msdn.microsoft.com/en-us/library/bb934049.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
September 22, 2014 at 5:39 am
Koen Verbeeck (9/22/2014)
Eirikur Eiriksson (9/22/2014)
There are some other topics missing, some points also went missing, all happened more or less at the same time.😎
Iek, now that you mentioned it, I...
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
September 22, 2014 at 5:32 am
Surely he expects you to figure it out by yourself? Are you going to tell him, when you present the answers, that they were given by other people?
Anyway, I already...
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
September 22, 2014 at 5:29 am
Maybe someone accidentally the Thread while cleaning up the weekend's spam (all 8 odd pages of it)
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
September 22, 2014 at 4:34 am
SELECT ID, Country + '+{' + CAST(Code as CHAR(2)) + '}' AS Country
From TableName
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
September 22, 2014 at 2:44 am
Disable the sa account and leave it disabled.
For an admin account, create your own, windows authent or SQL authent, strong passwords, password policy, all the usual security steps
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
September 19, 2014 at 3:50 pm
I believe they can both run in parallel.
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
September 19, 2014 at 3:44 pm
What exactly are you doing?
Those aren't roles applied to logins. They are database roles, they are applied to the database user.
Is the login a member of the sysadmin fixed server...
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
September 19, 2014 at 7:32 am
Offline = index unavailable for the duration of the operation
Online = index is available for most of the duration of the operation, more resources required, may take longer than an...
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
September 19, 2014 at 6:43 am
You don't alter the role. Users can have many roles. Remove that user from the db_owner role, then add him to the roles you want him to have.
sp_adddbrole and sp_removedbbrole...
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
September 19, 2014 at 6:41 am
Looks like they're scenarios which the previous DBA has set for him.
i was in to a new organization has to handel the entire setup singly there is no other...
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
September 19, 2014 at 3:56 am
If you have no DR server, then yes, the DB is down until you can finish the restore. No way around that. That's why critical servers should have HA/DR plans,...
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
September 19, 2014 at 3:46 am
Oh, so these are interview questions you're posting here, not a real set of database problems? Good to know.
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
September 19, 2014 at 3:40 am
Viewing 15 posts - 7,741 through 7,755 (of 49,552 total)