|
|
-
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......
|
|
-
11
Liked
| 11
Learned
| 6
Comments
|
|
This query comes as an answer to the following tek-tips forum thread http://tek-tips.com/viewthread.cfm?qid=1672424
The task was to extract 7 digit numbers from a string.
My solution is a simple straight-forward recursive CTE, although perhaps a b......
|
|
-
|
|
Because, SSRS 2005, it required Internet information services (IIS) to rum, where as in SSRS 2008, it no longer requires IIS. 2008 uses http.sys driver and listens for report requests through http.sys. Not only does this reduce deployment headaches, it ......
|
|
-
15
Liked
| 11
Learned
| 5
Comments
|
|
It is because sp_helptext may not return the correct procedure name as it returns text from syscomments system table. When a procedure is renamed using sp_rename, the text column of this table is not updated.
Consider this example
[code]
create proce......
|
|
-
10
Liked
| 11
Learned
| 5
Comments
|
|
While the following is not valid
[code]SELECT SYSDATETIME()-SYSDATETIME()[/code]
the following is valid
[code]SELECT SYSDATETIME()-GETDATE()[/code]......
|
|
-
11
Liked
| 11
Learned
| 3
Comments
|
|
I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query.
[code]
USE MSDB
GO
Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@s......
|
|
-
15
Liked
| 11
Learned
| 0
Comments
|
|
Suppose, We need to block the access to current database and for that decided to make the db offline.
For this, right click db->task-> offline.
But it won't work, if some connection still open.
Fix:
[code]
ALTER DATABASE <dbname> SE......
|
|
-
12
Liked
| 11
Learned
| 3
Comments
|
|
Heard of Space function?
It returns a string of repeated spaces.
Syntax:
SPACE ( integer_expression )
integer_expression : Is a positive integer that indicates the number of spaces. If integer_expression is negative, a null string is returned.......
|
|
-
11
Liked
| 11
Learned
| 1
Comments
|
|
Blocking and resource contention are not always the cause of locks in SQL Server therefore not always the cause of query performance degredation........
|
|