|
|
-
|
|
<table border="0" cellspacing="0" cellpadding="2" width="783"> <tbody> <tr> <td valign="top" width="781"> <p>Recently one of my friend called me and asked me that his MS SQL SERVER Database server is crashed and the problem is, he has the database backups on the same server. So now as the server is ......
|
|
-
|
|
Recently, we have weekly meetings with my team and one of developer is come up with question that, "Can we use Reports without having SQL SERVER Report Services?". That is very good question that came up by him, as he says client does not want to have SQL SERVER Reporting Services. Client SQL SERV......
|
|
-
|
|
Great News, Community TechDays event is back on 11th June, 2011 at Ahmedabad. This time I got a chance to have a session in this Community TechDays.
There are attractive sessions as follows:
1. HTML5 - Future of the Web, Harish Vaidyanathan, Evangelist Lead, Microsoft2. SQL Server Performance Tun......
|
|
-
|
|
Many times I found that the Reporting service is configured to access as "Anonymous Access", so any user having URL can access reports from external world. Ideally it should be access by only users/application. For that SQL SERVER Reporting service should not be accessed by "Anonymous Access". ......
|
|
-
|
|
Report is a better presentation of data. From report user/Management can easily
analyze the information. Report is easy to explain such information like Sales graph,
profitability etc..
......
|
|
-
|
|
Recently we have performance issue in SQL SERVER and we decided to move some large tables to different file group, so we can improve SQL SERVER performance, as it uses other disks I/O. Now challenge is to identify large tables from many tables (approx 700 tables).There are few ways to display row co......
|
|
-
|
|
Recently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details.
SELECT OBJECT_NAME(ObjectID) as ObjectName,
st.Text,
DB_NAME(database_ID) as dbname,
......
|
|
-
|
|
As I explained earlier about
For Each Loop Container, which process each file from selected folder.
There is a requirement to save File name along with record, so later on we can identify
......
|
|
-
|
|
We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted and we need to start some processes. I found that SQL SERVER provides a way to call Stored Procedure when SQL services are restarted.
SQL SERVER provides this SP: “sp_procoption”, which is auto executed ev......
|
|
-
|
|
We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted
and we need to start some processes. I found that SQL SERVER provides a way to call
Stored Procedure when SQL services are restarted.
SQL SERVER provides this SP: "sp_p......
|
|