Viewing 15 posts - 1 through 15 (of 17 total)
Unfortunately, the correct answer is not in the list: Turn the source database into a read only mode before running a tail-log backup
November 18, 2021 at 11:31 pm
Thank you Daniel for a very good feature comparison. Although, I agree with the reasoning and comparison, I cannot agree with the outcome. For me as a DBA, SSMS is...
November 15, 2021 at 1:13 am
For me it looks like a bug when driver converts parameter types like this.
April 30, 2021 at 6:28 am
Sergiy, below is what happens when parameter passed as variable
Here is the query:
And here how it is actually executed on remote server:
Please note that...
April 30, 2021 at 6:26 am
Thank you ScottPletcher, your method worked. The query was executed on remote server "as is". The only downside of this method is inability to use parameters. However, this is better...
April 30, 2021 at 6:21 am
Here is a sample query executed on a SQL Server:
This is how this query get actually executed on a remote server (caught by SQL Profiler). Please note...
April 26, 2021 at 11:27 pm
It's varchar on both ends. However, collations are different. One on remote server is CS while local CI.
April 23, 2021 at 5:21 am
You right, but it's absolutely wrong. Must be considered as a bug
September 1, 2020 at 6:01 am
Nice question!
Try this: SELECT 9test, 1prod;
which is equivalent to
SELECT 9 test, 1 prod;
SELECT 9 AS test, 1 AS prod;
Looks like when name starts with number, SQL interprets it as a...
November 25, 2019 at 6:33 am
Not exactly correct question. The right answer depends on assumption. We do not need to guess if other permissions were given to use or not. The question should state that
October 4, 2019 at 12:12 am
That's ok. It is possible to rewrite code to use different rules.
For example, you may define Ship_Definitions table as
IF OBJECT_ID (N'tempdb.dbo.#temp_Ship_Definitions', N'U') IS NULL
BEGIN
CREATE TABLE dbo.#temp_Ship_Definitions
(
...
June 30, 2014 at 10:24 pm
Hi Sean,
Great program, I had a lot of fun playing and analyzing it.
The only problem I found is that ship placement is not random enough which makes it easy to...
June 29, 2014 at 9:54 pm
Why don't use old and reliable bcp utility?
You can export your table into file by something like
bcp Table out FileName.dat -S server -d database -n -T
and then import it back...
November 9, 2011 at 7:12 pm
Hi Rasmus,
it is possibly to simplify your script up to one select statement ;-):
SELECT 'EXEC sp_addsrvrolemember '''+pr.name+''', '''+pm.name+''''
FROM sys.server_role_members AS rm
JOIN sys.server_principals AS pm ON rm.role_principal_id=pm.principal_id
JOIN sys.server_principals AS pr...
August 29, 2010 at 5:30 pm
Juts wanted to add my comment about the physical order of rows in table.
In case when clustered index defined on table they are in "physical order" (as per BooksOnline), and...
May 6, 2010 at 10:56 pm
Viewing 15 posts - 1 through 15 (of 17 total)