|
|
-
|
|
I usually take a backup and restore it when I need to move a database to another server/location. Just learned from Pinal's blog that SSMS offers a "copy database" option which allows you to copy or move a database from one location to another.
To star......
|
|
-
12
Liked
| 12
Learned
| 4
Comments
|
|
My 8 year old daughter just came back from school and asked me to help her do the home-work. I did not know that a female FOX is called VIXEN and just learned it from her text book.
Time to start learning some 'non technical' stuff !......
|
|
-
12
Liked
| 12
Learned
| 8
Comments
|
|
Recently watched an inspiring regional movie, where actor asks actress to take her birth date, and multiply day with 12 and Month with 31 and add those results. As soon as she tells the result, in 3-4 seconds, actor will tell her birth date. At first gl......
|
|
-
14
Liked
| 12
Learned
| 3
Comments
|
|
In my previous post, I showed how to find whether the request came from Mobile or PC. But later my requirement is extended to find whether the request came from IPAD or not also. For this. We can use Request.UserAgent, If it has the word "ipad", it mean......
|
|
-
15
Liked
| 12
Learned
| 0
Comments
|
|
Recently couple of times, I have a requirement of showing execution time to the users. Both times, I followed the approach of taking a starttime variable and stop time variable and calculating difference between those variables.
Today I saw an MSDN b......
|
|
-
13
Liked
| 12
Learned
| 11
Comments
|
|
Adding the /NOSPLASH option to your Visual Studio\BIDS shortcut will make Visual Studio\BIDS launch quicker :
%ProgramFiles%\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe /NOSPLASH
%ProgramFiles(x86)%\Microsoft Visual Studio 10.0\Common7\IDE\d......
|
|
-
14
Liked
| 12
Learned
| 4
Comments
|
|
During working with replication, encountered with one error to use actual server name for replication. For solution we need to change the SQL Server instance name as actual server name with following,
[CODE]
EXEC sp_dropserver 'Old Server Name'
EXE......
|
|
-
11
Liked
| 12
Learned
| 1
Comments
|
|
SQL Server History
[code]
Version Year Release Name Codename
--------------- -------- ----------------------------------- --------------------
1.0 (OS/2) 1989 SQL Server 1.0 (16bit) -
1.1 (OS......
|
|
-
15
Liked
| 12
Learned
| 8
Comments
|
|
There is something $IDENTITY to get the identity value for a table contained the identity column.
[Code]
create Table T1(Col1 int identity(1,5),Col2 int)
Go
Insert into T1(Col2) Select 100
Go 100
Select $Identity,* From T1
[/Code]......
|
|
-
18
Liked
| 12
Learned
| 10
Comments
|
|
There are no non-logged user database operations. The only non-logged operations are the version stores in tempdb
TRUNCATE TABLE is minimally-logged:
1) Metadata changes are always logged at TRUNCATE time
2) Extent/page deallocations may be logged......
|
|