|
|
-
13 Liked
| 12 Learned
| 1 Comments
|
|
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
|
-
|
|
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......
|
|
-
|
|
Just learned from Pinal's blog about right align the numeric value in output pane of SSMS.
Go to Tools -> Options -> Query Results -> Results to Text, Check the checkbox, "Right align numeric values"
Once this setting has been done, when the query is...
|
|
-
|
|
If you ever add a default constraint on a table without giving it a name, SQL Server will give it a somewhat random name which you cannot guess.
To drop those constraints such a query might come in handy:
DECLARE @query NVARCHAR(MAX)
SET @query...
|
|
-
|
|
When using INSERTs on large tables (> 1 millon rows), the SCOPE_IDENTITY() or @@identity functions sometimes return wrong results.
(*This was NOT supposed to be fixed in SQL Server versions older than 2012!*)
**Update:** It seems the problem has been ...
|
|
-
|
|
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to help...
|
|
-
|
|
Just learned that in SSIS 2008 Script task skips Breakpoints in run in 64 bit environemnt. Goto solution porperties -> Debugging and set Run64bitRuntime to False and the Script task will start debugging....
|
|
-
13 Liked
| 10 Learned
| 0 Comments
|
|
Wordpress.com allows us to post code on blogs using [sourcecode] tag. For instance, a SQL code will be posted using:
[code]
[sourcecode language="SQL"]
your code here
[/sourcecode]
[/code]
For more information URL: http://en.support.wordpr......
|
|
-
13 Liked
| 11 Learned
| 10 Comments
|
|
Microsoft has a free SEO toolkit, which can be used to identify the SEO problems in your website. You can install it from here.
http://www.microsoft.com/web/seo/
Once, you install the tool, you can open IIS and analyze any website. Once analysis ......
|
|
-
13 Liked
| 11 Learned
| 2 Comments
|
|
Though I know viewstate is vulnerable to security as it reveals sensitive information, I always thought that its reasonably difficult to decode. But i found that decoding viewstate is very much simpler. ASP.NET has a class "LosFormatter", by using which......
|
|