Viewing 15 posts - 43,246 through 43,260 (of 49,552 total)
Don't shrink the databases. It causes massive fragmentation of indexes.
You can, as a once off operation, shrink the log down. If, however the log file needs to be that...
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
November 10, 2008 at 1:28 am
madhu.arda (11/9/2008)
I would like to test the following recovery scenario:
1.There is some activity has been done on database 'abc' from 3:00pm to 3:10pm
2.stop sql server delete ldf file of...
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
November 10, 2008 at 1:25 am
rosh (11/9/2008)
GilaMonster (11/8/2008)
rosh (11/6/2008)
Would null values cause this.See if ISNULL helps.
Null won't cause a divide by zero. Anything divided by null (or added to null or multiplied by null, ...)...
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
November 10, 2008 at 1:11 am
vempralachaitanya (11/9/2008)
But can you please tell me why the where clause is bouncing and what is the reason?
Bouncing?
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
November 10, 2008 at 1:08 am
UPDATE t SET t.sno = s.sno
FROM t INNER JOIN s ON s.sid=t.sid
WHERE t.sno IS NULL
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
November 9, 2008 at 12:22 pm
Access or SQL Server?
Can you post the table definitions, an example of the data that would be inserted and the end results that you want?
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
November 9, 2008 at 12:15 pm
A calculated column can only refer to columns within the same table.
From Books online
A computed column is a virtual column that is not physically stored in the table but is...
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
November 9, 2008 at 12:12 pm
For parameters it'll look more like this.
SELECT [Lesson_Schedule].[Lesson_Date], [Lesson_Time].[Lesson_Time], [Student].[Student_Id],
[Student].[First_Name], [Student].[Last_Name], [Lesson_Type].[Duration_Time]
FROM Student
INNER JOIN Booking ON [Student].[Student_Id]=[Booking].[Student_Id]
INNER JOIN Staff ON [Staff].[Staff_Id]=[Booking].[Staff_Id]
...
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
November 9, 2008 at 12:08 pm
Can you post the code for the function that gets the employee codes please, along with the code for any functions it calls. Also please post the table definition.
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
November 9, 2008 at 1:45 am
I'd say stored proc. Have the form call the proc when it's saved and have the proc do the inserts into the two tables.
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
November 9, 2008 at 1:36 am
cindy_sinath (11/8/2008)
WHERE [Staff].[Staff_Id]=[Enter Staff ID] And [Lesson_Schedule].[Lesson_Date] Like "*" & [Enter the Date] & "*";
What's the intention with this line? SQL, unlike Access, doesn't prompt for data entry. This is...
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
November 9, 2008 at 1:35 am
Good one! Anybody can try using this to recover records deleted from tables in SQL Server 2000.
Providing the log records are there. Backups are still (and probable always will be)...
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
November 8, 2008 at 3:31 pm
why not....
Hint hell:
SELECT CompanyName, OrderDate, ProductName, OD.UnitPrice, Quantity, SUM(OD.UnitPrice) * Quantity TotalPrice
FROM Orders O with (INDEX = CustomerID)
INNER LOOP JOIN [Order Details] OD WITH (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
November 8, 2008 at 3:20 pm
Do you have a backup of master?
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
November 8, 2008 at 3:00 pm
Can you post the table definitions (as create scripts), some sample data (as insert statements) and your expected results please?
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
November 8, 2008 at 2:36 pm
Viewing 15 posts - 43,246 through 43,260 (of 49,552 total)