SQL Login user should have sufficient level of privileges to performance required actions on the related tables. Then shouldn't be having any issue...
Share your problems as problem analysis will be better manner and so solution(s). As it's looks you should be having calculative data for each day...
Hi All I have a query that need to Rewrite it without cursor, function or loop to produce same result and should be included in ONE SELECT (no...
Hi All I am importing data every 5 minutes from production server using linked server. This service (job) running on 2 server e.g. fetching data...
You mean to say that when midnight come or cross, the getdate() value change to next date and date range change according for the next day and it...
I do not know that you might or might not have idea how much this kind response can help people here.... Now I can read more literature on hardware...
Initial size will 15 GB and approx.. grow 30% every year...
No I haven't contact any vendor yet as I want to understand some basic knowledge on the area. And that's why I have asked here in forum for help. I...
Hi With those links I have tried to understand what would be the best possible hardware for DWH. I came up with following specs but not sure I am on...
I need to do sizing the DWH DB server. The current scenarios are... Serversthat will last min 5 years (or want to retain 5 years data) Averagetotal...
Reason to ask this is that I want to weigh up the CPU utilization, number of transactions and memory usage of DB Server... see if DMVs can help...
Here are couple of more refers for this Error......
I have found the answer here... http://dbaonline.wordpress.com/2008/07/10/troubleshooting-sql-2005-performance-dashboard/
Hi I have following error came up when I click on any blue region in the chart for the SQL CPU utilization on the performance dashboard where you...
I am wondering that is there any DMV that give us occurrence of different statements on the server for DBs. I have found one ....but not sure if...
Well... thanks all of you ....Satya I have download the book and found really solid on the subject. Thanks Once again....
Ok, let me elaborate the need... I need to capture number of T-SQLs (sps, functions, triggers, single T-SQLs) hits on the databases exist on a...
I knew that i can view in profiler for specific db, event etc....But transfer in table for analysis? Thanks....
Hi All I need to capture T-SQLs and transactions that run on SQL Server DB. How do I capture this information into table? Thanks in Advance...
Separate names with a comma.
