|
|
-
Patrick Lambin Learned 5 Months ago through Just Learned | 1 Point
This short tip is a result of my quick research in attempt to solve this MSDN thread
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f02aefbd-09a5-4336-84d2-d67bdf238221
In order to use case sensitive search with PATINDEX we need to...
|
-
Patrick Lambin Learned 1 Years ago through Just Learned | 1 Point
Reason: This is because SQL Server 2008 Express with Advanced Services includes the Full-Text Search feature And as you know that it is one of the per-requisite to install adventure works sample db's in any edition.......
|
-
Patrick Lambin Learned 1 Years ago through Just Learned | 1 Point
Reason: This is because SQL Server 2008 Express with Advanced Services includes the Full-Text Search feature And as you know that it is one of the per-requisite to install adventure works sample db's in any edition.......
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
I just learn from Abhishek Sur blog That future of C# 5.0 introduce two new keywords like "await" and "async" keyword for simplified existing multithreading model
[code]
async Task GetStringsFromUrlAsync(string url)
{
WebClient client = new ...
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
I just learn from Abhishek Sur blog That future of C# 5.0 introduce two new keywords like "await" and "async" keyword for simplified existing multithreading model
[code]
async Task GetStringsFromUrlAsync(string url)
{
WebClient client = new ...
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
I would like to share a script to add tables in existing publication in transactional replication,
[CODE]
USE PublisherDB
GO
exec sp_addarticle
@publication = N'PublicationName',
@article = N'TableName',
@source_owner = N'SchemaName',
@sou...
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
I would like to share a script to add tables in existing publication in transactional replication,
[CODE]
USE PublisherDB
GO
exec sp_addarticle
@publication = N'PublicationName',
@article = N'TableName',
@source_owner = N'SchemaName',
@sou...
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
I have just tried to connect SQL Server default local instance by providing "." as server name and able to connect. We can connect with "(local)" also.......
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
I have just tried to connect SQL Server default local instance by providing "." as server name and able to connect. We can connect with "(local)" also.......
|
-
Patrick Lambin Learned 2 Years ago through Just Learned | 1 Point
Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching
[code]
alter table...
|