Viewing 15 posts - 43,336 through 43,350 (of 49,552 total)
I wouldn't bother creating a backup device for a once-off backup, and if you run that more than once, you may get an error saying the backup device already exists.
Just...
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 4, 2008 at 12:54 pm
No. Literal text hasn't been changed and your first query would throw an error saying no such column as SomeText
SELECT tbl.Column AS [MyColumn], 'SomeText' AS [LiteralText]
FROM MyTable AS tbl
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
November 4, 2008 at 12:12 pm
Once you've set it back to full, you'll have to take a full database backup or your backup software, which I assume does log backups, will fail.
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 4, 2008 at 12:07 pm
Maybe. They're not indexes and as such they won't directly improve performance. They do give the optimiser more information about the data hence allowing it to produce better execution plans
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 4, 2008 at 12:02 pm
Fernando (11/4/2008)
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 4, 2008 at 12:00 pm
Mani (11/4/2008)
This differential backup cannot be restored because the database has not been restored to the correct earlier state. (Microsoft.SqlServer.Smo)
That's saying that the 6am diff is not based off 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
November 4, 2008 at 11:53 am
You can't disable logging. It's not an optional component of the database.
What you can do is set the database you're doing the transfer into simple recovery. Since it's not a...
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 4, 2008 at 11:49 am
You can, but unless you figure out why the log is growing, it's just going to get back to that size in time.
What recovery model?
If full or bulk-logged, how often...
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 4, 2008 at 11:42 am
Actually, I've just finished writing a short 'chapter' for a book. 😀
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 4, 2008 at 11:32 am
balbirsinghsodhi (11/4/2008)
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 4, 2008 at 11:30 am
KATHLEEN Y ZHANG (11/4/2008)
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 4, 2008 at 10:26 am
Are you seeing any particular wait type? (check sys.dm_exec_requests)
Is one of the logins sysadmin and the other not?
Do they both have the same default schema?
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 4, 2008 at 9:52 am
Which one are you running? What indexes are there on the Emp 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
November 4, 2008 at 8:16 am
I'd suggest move it to a larger drive. If it's filling up with a simple update and a temp table, then the drive it's on is probably too small.
How...
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 4, 2008 at 8:08 am
Is tempDB restricted in size? Is it on a drive that's full?
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 4, 2008 at 7:43 am
Viewing 15 posts - 43,336 through 43,350 (of 49,552 total)