Viewing 15 posts - 33,796 through 33,810 (of 49,552 total)
It doesn't appear to. I just tried it out, switching my server to french and running the reports. Still in English.
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
February 26, 2010 at 7:22 am
What reports?
Changing the language will not translate data stored in the database, nor will it translate anything that's explicitly put on to a report, if we're talking about reporting services...
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
February 26, 2010 at 6:59 am
river1 (2/26/2010)
Don't understand what is this "Run the RECONFIGURE statement to install."
It's referring to the RECONFIGURE statement, the one in the script you posted. Any change to sp_configure will produce...
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
February 26, 2010 at 6:25 am
river1 (2/26/2010)
No, i see this button in the SQL Server Management Studio (relational databases).
Where? What menu? What window? What dialog? etc
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
February 26, 2010 at 6:20 am
You said there's a button that's greyed out. Where is 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
February 26, 2010 at 5:14 am
Where is said button?
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
February 26, 2010 at 4:43 am
These may be worth reading
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
February 26, 2010 at 4:18 am
winslet (2/26/2010)
On production server is this a good practise to change the recovery mode to simple , ReBuild indexes and switch back to FULL.? Please confirm.
No. Terrible practice. Switching 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
February 26, 2010 at 2:08 am
miss.delinda (2/26/2010)
I understood each table must have a Identity Field called trnxid (transaction id)
There are no such requirements in SQL. There's no requirement that a table MUST have an identity...
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
February 26, 2010 at 12:34 am
mohammed moinudheen (2/25/2010)
Do you recommend this on a production environment. Just wanted to confirm with you as I face space issues sometimes on the log drive during maintenance operations.
Yes, providing...
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
February 26, 2010 at 12:26 am
Actually, there's one more if this is a once-off update.
Run the update in master and use 3-part naming to reference the DB in question. Compat mode is controlled by 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
February 25, 2010 at 2:52 pm
You could switch to bulk-logged for the duration of the index rebuilds. Otherwise, leave it alone, maybe increase the frequency of the log backups (the shipped ones) during the index...
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
February 25, 2010 at 1:02 pm
zukko (2/25/2010)
UPDATE Departments
SET DeptSeq = cte.deptSeq
FROM (
SELECT Department, ROW_NUMBER() OVER (Partition By Department Order By...
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
February 25, 2010 at 1:01 pm
You can, but you really shouldn't be considering shrinking the database at all.
Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets...
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
February 25, 2010 at 12:25 pm
B. Hill (2/25/2010)
second, I want to update the DeptSeq column to the incremented value. Does this query do this?
No. I wrote a select for you. A select returns data,...
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
February 25, 2010 at 12:20 pm
Viewing 15 posts - 33,796 through 33,810 (of 49,552 total)