|
|
-
Khyati Patel Liked 10 Months ago through Blogs
One of my office colleague recently asked me why we are not able to generate ALTER Table script from SSMS. If we right click on the table and choose "Script Table As" ALTER To option would be disabled or Greyed out. Is it a bug?...
|
-
Khyati Patel Liked 10 Months ago through Tutorials
In this chapter, we learn how the SQL Server Profiler and the SQL trace can help us in identifying deprecated features from our database code....
|
-
Khyati Patel Learned 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 ...
|
-
Khyati Patel Liked 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 ...
|
-
Khyati Patel Learned 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 ...
|
-
Khyati Patel Liked 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 ...
|
|
|
-
Khyati Patel Liked 10 Months ago through Blogs
Despite knowing that backups are the key tools when it comes to dealing with all forms of database corruption, I never bothered to take routine backups....
|
|
|
-
Khyati Patel Liked 10 Months ago through Tutorials
In this chapter, we learn how to execute a trace and how to define trace execution options to our benefit by defining the maximum amount of data to capture and using time-bound tracing. ...
|