Viewing 15 posts - 12,406 through 12,420 (of 49,552 total)
DivyaMohankumar (7/11/2013)
5) Now my question is how can i get the old values in the table , as i inserted.
Get a backup that was taken before the update was done,...
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
July 11, 2013 at 6:13 am
Ok, so it's not actually running as 'sa'
Can you security properties for that login, whether it's mapped to any databases and if so what the default schemas 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
July 11, 2013 at 1:16 am
Can you add a bit to that step that writes into some log table the database user name being used and the login name?
Suser_Sname() for login and USER_NAME() for database...
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
July 10, 2013 at 3:56 pm
Any SQL Agent proxies in place?
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
July 10, 2013 at 3:21 pm
Contrived, but maybe you'll be able to use this as a starting point.
CREATE TABLE Employees (
ID INT IDENTITY(0,1),
EmployeeID AS ISNULL(ID+5000000,0) PERSISTED,
FirstName varchar(50),
LastName varchar(50),
Library AS (ID+1832) PERSISTED,
Food AS (ID+880101802147) PERSISTED
)
ALTER TABLE...
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
July 10, 2013 at 3:20 pm
If SQL Agent is running as sa, then it will be running under the dbo user in the database and hence it's default schema is dbo.
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
July 10, 2013 at 2:32 pm
Ok, so how is the Employee number calculated, how is the barcode calculated? How is the Employee food calculated? Are they all just straight incrementing from the previous number?
Can you...
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
July 10, 2013 at 1:12 pm
ktager (7/10/2013)
Gail, thanks, I was going to do some testing on controlling it myself. Unfortunately, there is no was to use the Identity field to calculate off of.
Why...
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
July 10, 2013 at 12:04 pm
Start->Program Files->Microsoft SQL Server->Documentation and Tutorials->SQL Server Books Online (or press F1 in Management Studio)
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
July 10, 2013 at 9:40 am
The only auto-increment in SQL 2008 is the identity. You can try and roll your own increment (easy to get wrong) or maybe you can set up the other two...
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
July 10, 2013 at 9:34 am
It's exactly the same as mirroring with a witness, you just leave out the step where you configure a witness. It's all detailed in Books Online, all the major options.
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
July 10, 2013 at 9:26 am
Without shutting SQL Server down, you cannot copy the files of the system databases.
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
July 10, 2013 at 8:48 am
poratips (7/10/2013)
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
July 10, 2013 at 7:56 am
dwain.c (7/9/2013)
Thanks for the clarifications. I take it you're saying that even with a MAXDOP 1 on the simple SELECT it doesn't guarantee row ordering.
The only thing that guarantees...
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
July 10, 2013 at 1:54 am
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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
July 9, 2013 at 2:16 pm
Viewing 15 posts - 12,406 through 12,420 (of 49,552 total)