Viewing 15 posts - 1 through 15 (of 18 total)
Carlo, you are right!
use tempdb
go
CREATE TABLE NewTable (record BIT);
GO
DECLARE @tsql nvarchar(max);
Set @tsql = N'SELECT SUM(CAST(record AS INT)) from NewTable';
SELECT * FROM sys.dm_exec_describe_first_result_set(@tsql, null, 0);
Set @tsql = N'SELECT...
April 24, 2023 at 7:57 am
The answer should be: I get the two statements concatenated together, not the strings are concatenated, because there is no execution!
October 15, 2021 at 6:13 am
Same for me!
Just try to insert a
Set implicit_transactions off;
just after the Rollback;
March 18, 2021 at 7:49 am
Nice question, but you should end the statement with a semicolon, so that the next statement will work if it contains a cte, too!
November 22, 2019 at 6:42 am
I've chosen "Add a WHERE clause to your CREATE STATISTICS DDL", but all options are wrong. But the explanation is "You can use a WHERE clause with expression(s) just as...
May 2, 2019 at 5:52 am
But this is not true for Basic Availability Groups, isn't it?
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-2016
An Always On basic availability group can be created on any two SQL Server 2016 Standard...
November 15, 2018 at 3:10 am
Setting the database offline as the first step and bringing it back online at the end would be a good idea!
January 22, 2018 at 2:49 am
Nice article, but I'm missing a hint to adhoc queries and their influence on the proc cache. You can save a lot of memory by using the optimize for ad...
January 31, 2012 at 7:08 am
There was one step missing in your list. After:
4. Restored the latest backup of the master database.
There should be another restore:
4a. Restored the latest backup of the msdb database.
Kind regards,
Christoph
May 16, 2011 at 6:35 am
After restoring master it is only necessary to attach the databases which were created after the last backup of master. All other databases should be available immediate.
Cheers,
Christoph
May 16, 2011 at 6:30 am
Good story! I think, you should as well add the link to the MSDN Library.
Rebuilding System Databases
http://msdn.microsoft.com/en-us/library/dd207003(v=SQL.100).aspx
Please tell us more about the reason of the corruption and why restoring...
May 16, 2011 at 3:17 am
Try it with SQL Server 2000! It's funny!
Cheers,
Christoph
February 24, 2011 at 12:56 am
I've just used the facets method with SSMS 2008 and SQL Server 2005. It is working! So you should give the points to the answer SSMS!
Greetings
Christoph
February 24, 2011 at 12:49 am
Viewing 15 posts - 1 through 15 (of 18 total)