Viewing 15 posts - 18,751 through 18,765 (of 49,552 total)
Yup, absolutely there is. It's one of those undocumented features.
DBCC TRACEON (3604)
DBCC DBINFO
From my testing DB:
DBINFO @0x00000000127BE060
dbi_dbid = 10 ...
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
April 26, 2012 at 2:09 pm
guy 10462 (4/24/2012)
BACKUP DATABASE WibbleTO DISK = 'C:\Backups\Wibble.bak'
MIRROR TO DISK = 'D:\Backups\Wibble.bak'
...am I right in assuming this will do what I want?
Yes it will. It will write the complete backup...
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
April 26, 2012 at 1:57 pm
Steve Jones - SSC Editor (4/26/2012)
GilaMonster (4/26/2012)
Steve Jones - SSC Editor (4/26/2012)
GilaMonster (4/26/2012)
Steve Jones - SSC Editor (4/26/2012)
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
April 26, 2012 at 1:07 pm
Lynn Pettis (4/26/2012)
Ohhhh! Can I send you my crystal ball so you can fix it?
Sure. My cats need a new toy. The chips and scratches don't interfere too much.
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
April 26, 2012 at 1:04 pm
Steve Jones - SSC Editor (4/26/2012)
GilaMonster (4/26/2012)
Steve Jones - SSC Editor (4/26/2012)
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
April 26, 2012 at 1:01 pm
Well that bears no resemblance to the code I gave you but still.
Yes, you can do it there.
if (consolidate = 1)
set @Portfolio = '+' + @Portfolio
You really, really,...
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
April 26, 2012 at 12:56 pm
When you try to execute what?
The physical name of a log file is irrelevant, it can be anything you like.
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
April 26, 2012 at 12:51 pm
Lynn Pettis (4/26/2012)
GilaMonster (4/26/2012)
capn.hector (4/26/2012)
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what...
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
April 26, 2012 at 12:49 pm
If you bother to show me what the query is, I might be able to answer that.
But no, you wouldn't declare a new variable, you would use that boolean...
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
April 26, 2012 at 12:45 pm
capn.hector (4/26/2012)
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what the problem was....
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
April 26, 2012 at 12:40 pm
Whereever you need that parameter to have it's value as set as requested. In the query though, not the report.
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
April 26, 2012 at 12:39 pm
Sure, it's a backup file, you need to restore it onto the new server. You can do that through the SSMS GUI or you can use the RESTORE DATABASE T-SQL...
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
April 26, 2012 at 12:38 pm
CASE @BooleanParameter WHEN 1 THEN '+' + @OtherParameterValue ELSE @OtherParameterValue END
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
April 26, 2012 at 12:33 pm
Steve Jones - SSC Editor (4/26/2012)
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
April 26, 2012 at 12:18 pm
Mias12 (4/26/2012)
Hi, I was wondering if there is a way to Re-index only the tables in my database that have more than 1000 records.
The general recommendation for what tables 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
April 26, 2012 at 11:50 am
Viewing 15 posts - 18,751 through 18,765 (of 49,552 total)