|
|
-
|
|
Hide PDF export option from Report Viewer toolbar.
Step - 1
Locate the file name "RSReportDesigner.config" at
"Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config".
Note: Location of the file varies in different ver......
|
|
-
|
|
I faced this error mentioned in title while running stored procedure in local server which updates data in remote server. I was able to fetch data from remote server but couldn't update through linked server. I checked the linked server and access but i......
|
|
-
|
|
SSIS has a built in capability to import from multiple files in parallel. We can create MultiFlatFile connection manager to acheive this.......
|
|
-
|
|
I just learned one new thing today "How to know database backup details like DBname,backup start time,backup end time,recovery model,total DBsize,backup location etc.with t-sql." check out following query.
[code]
USE MSDB
GO
SELECT database_name a......
|
|
-
|
|
SQL Server decides the operation based on higher precedence of data type of values.
What SQL server does is to look at the precedence of the data types involved in an operation. When you perform an operation that involves multiple data types, SQL Ser......
|
|
-
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.......
|
|
-
|
|
Table : a normal container to create report
Matrix : create report which has variable columns and rows (like Pivot table).
Tablix: Mixture of Table and Matrix.......
|
|
-
|
|
Today, I learnt something new which is not really new but unknown for me about ODBC scalar functions. I never see people used these functions very frequently. Thought of sharing with all....
Eg:
select {fn current_date()}
select {fn current_time()}......
|
|
-
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........
|
|
-
|
|
Which one is better to use index on table or not?
Simple answer is for Small table no and for table with huge data yes.......
|
|