Viewing 15 posts - 41,146 through 41,160 (of 49,552 total)
The file that you're trying to restore (which looks like an mdf file) is not a valid backup.
Can you explain more what you're trying to do, with what files and...
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 9, 2009 at 11:00 am
saby (2/9/2009)
add more tempdb files
TempDB is database ID 2, not database ID 6
samsql: Are you getting latch waits? What's happening at the time? Can you post full message if there's...
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 9, 2009 at 10:55 am
terryj30 (2/9/2009)
I really wound not recomend this but it will create you a new tranlog that is empty.
I would not recommend that under any circumstances. It's the quickest way...
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 9, 2009 at 10:50 am
Depends on the type of crash. If the tran log is still available and SQL is still running, then you can take a tail-log backup (see books online for details,...
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 9, 2009 at 10:48 am
gyessql (2/9/2009)
I am a little confused. The first part says to use local variables, the second part says using parameters is better than local variables. Which is better?
I don't...
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 9, 2009 at 10:39 am
ALZDBA (2/9/2009)
I know it should do the same as between, but I've read somewhere datetimes and between did cause some issues.(Although I haven't got an url available)
It will run 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 9, 2009 at 10:32 am
DavidB (2/9/2009)
Ratheesh.K.Nair (2/9/2009)
I have run some update statistics and index reorganize commands but they are not shown in SQL Server logs.
Have you seen somewhere that these are logged events? 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
February 9, 2009 at 10:28 am
jmazzolini (2/9/2009)
Does anyone have any suggestions? I am looking for high quallity training with experienced people...more than simple test preparation.
Where in the world are 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
February 9, 2009 at 10:15 am
Not unless there was a profiler trace running
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 9, 2009 at 10:14 am
trans54 (2/8/2009)
How about the order of the INCLUDE? Does it matter in this case?
As I said in the post above
and order of include columns doesn't matter because they are only...
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 9, 2009 at 10:09 am
ankur.bhargava (2/9/2009)
Hi All,Thanks for your replies. Below is the stored procedure which I am running.
What, at a high level, is it supposed to do?
Microsoft SQL Server 2005 - 9.00.1399.06...
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 9, 2009 at 10:06 am
sqlfriend (2/9/2009)
Hi, just got an update: It's 14 filegroups with one file each. They are all on the same SAN/LUN based on several physical drives.
If they are all on...
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 9, 2009 at 10:04 am
Parameter sniffing, or more accurately the lack of parameter sniffing. SQL doesn't know the values of the variables at compile time and hence guesses the rows affected. If it guesses...
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 9, 2009 at 10:00 am
Barkingdog (2/8/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
February 8, 2009 at 1:38 pm
Why use intersect? If you're looking for matches, join the tables
update D
set isspecial = 1
from D inner join M on D.c1 = M.c1 AND D.c2 = M.c2 AND D.c3...
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 8, 2009 at 1:37 pm
Viewing 15 posts - 41,146 through 41,160 (of 49,552 total)