Viewing 15 posts - 36,226 through 36,240 (of 49,552 total)
Check error log before you try a reboot. If there's something wrong with the database that a reboot won't fix, then rebooting isn't going to help. Check what's wrong first,...
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
October 19, 2009 at 8:19 am
Have a look in the SQL error log, look for messages relating to that database.
If you have entries like this, then the DB is in restart-recovery and you'll have 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
October 19, 2009 at 8:09 am
Mr. Andersen (10/19/2009)
Anyone have a good idea on how I can maintain my log entries, even though the transaction has rolled back ?
Log to a table variable, they're unaffected 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
October 19, 2009 at 8:06 am
endeavour (10/16/2009)
Would you consider hiring a specialist consultant for performance and scalability issues in SQL?
Yes, absolutely. If you have no idea where to start and you have a performance/scalability problem...
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
October 19, 2009 at 5:23 am
namrata.dhanawade-1143388 (10/19/2009)
Even if there are duplicates in the select, will it not get caught in the if exists for the second insertion/ duplicate insertion ??
Insert ... select does not work...
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
October 19, 2009 at 5:18 am
ben.ward 42132 (10/19/2009)
I'm amazed that a single null in a recordset will make the whole query fail but nevermind eh 🙂
The query isn't failing. You're not getting error messages....
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
October 19, 2009 at 2:55 am
Brian McGee-355525 (10/19/2009)
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
October 19, 2009 at 2:46 am
Brian McGee-355525 (10/18/2009)
Two databases on same server. Query uses one table in each.Update DB2..IT
Set TTI = tds.TI
From DB2..IT it
Join TDS On it.TR = tds.DSR And it.DS = tds.DS
There's no...
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
October 19, 2009 at 2:03 am
bas de zwart (10/16/2009)
- Users would be unable to quickly check what's there in each field by using a 'SELECT TOP 100 * FROM OBJECT' query.
-...
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
October 19, 2009 at 2:03 am
alifah (10/18/2009)
its a direct relationship with foreign key programid..
Then you should have a join between the two tables on that column, just as you've joined applicant and intake
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
October 19, 2009 at 1:55 am
talltop-969015 (10/18/2009)
Remember ladies, reading is fundamental...
<raised eyebrows> Was that really necessary?
Personally I've seen far more males than females who wouldn't open a book if their lives depended on it. Might...
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
October 19, 2009 at 1:48 am
You can study any way you like. No one's going to restrict you there. The material is not the same in the two exams (no big surprise), so it might...
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
October 18, 2009 at 12:31 pm
The MCTS is a pre-requisite for the MCITP certification. You'll have to write and pass the TS exam first, then the PRO to get the certifications.
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
October 18, 2009 at 4:18 am
or seach Books Online for hardware requirements.
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
October 17, 2009 at 6:45 am
Sourav-657741 (10/17/2009)
What is the max size of one row of a table?
8060 bytes, excluding LOB data and not considering row versioning or other things that will reduce the available space...
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
October 17, 2009 at 4:16 am
Viewing 15 posts - 36,226 through 36,240 (of 49,552 total)