|
|
-
Johnbravo knew 10 Months ago through Just Learned
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...
|
-
Johnbravo knew 10 Months ago through Just Learned
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...
|
-
Johnbravo knew 10 Months ago through Just Learned
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Johnbravo knew 10 Months ago through Just Learned
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Johnbravo Learned 10 Months ago through Just Learned
You can execute procedure at start up of SQL Server instance.
To do that follow steps below:
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
GO
RECONFIGURE WITH OVERRIDE;
EXEC sp_configure 'scan for startup pro...
|
-
Johnbravo Learned 10 Months ago through Just Learned
You can execute procedure at start up of SQL Server instance.
To do that follow steps below:
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
GO
RECONFIGURE WITH OVERRIDE;
EXEC sp_configure 'scan for startup pro...
|
-
Johnbravo knew 10 Months ago through Just Learned
It was announced when office 2013 preview came out so in case you missed this awesome news: "Power View is Integrated in Excel 2013!" ...
|
-
Johnbravo knew 10 Months ago through Just Learned
It was announced when office 2013 preview came out so in case you missed this awesome news: "Power View is Integrated in Excel 2013!" ...
|
-
Johnbravo knew 10 Months ago through Just Learned
Just learned from Pinal's blog that you can open a web page within SQL Server Management Studio. You can even split the main window where on one side you can type your TSQL code and on the other half you can view web pages. This can be extremely helpful...
|
-
Johnbravo knew 10 Months ago through Just Learned
Just learned from Pinal's blog that you can open a web page within SQL Server Management Studio. You can even split the main window where on one side you can type your TSQL code and on the other half you can view web pages. This can be extremely helpful...
|