Topics
Started by
Posts
Last post
Hello Friends, I have build a stored procedure with some parameters inwhich i have build 40 or 50 d…
6 replies
We have a stored procedure having a delete statement based on few parameters. This stored procedure…
6 replies
Performance issue with one query. There is one select query from a view which does union all from t…
12 replies
Hi All, One of our reporting server query is running very slow, it takes more than one hour to exec…
12 replies
Hi, I have added an index to a table, as my query was doing a clustered index scan on it. After add…
11 replies
Hi, We have observed during a benchmark that SQL SERVER 2008 is around 30% slower than SQL SERVER 2…
7 replies
I have been tasked with identifying stored procedures to be deprecated in an older application, run…
3 replies
some people told when ever we are using char data type memory will be wasted …
18 replies
I have a client reporting sluggish performance on the principle server in a mirrored environment. R…
2 replies
HI, If SORT_IN_TEMPDB = ON Will this increase the time to REBUILD the indexes As compare with SORT_…
1 replies
good morning to all i have 4 tables like table1: create table plans(firstname varchar(10)) table2: …
1 replies
I have 4 SQL Server agent jobs. Each executes it's own set of SSIS packages. Now I want the jobs 1 …
8 replies
create table TB (StartDate datetime, StartTime datetime, EndDate datetime, EndTime datetime) declar…
10 replies
Hello Fellas, In my execution plan I can see clustered index seek for one table with only showing O…
10 replies
Hello, I have the next code: SELECT udf_datum([Timestamp]) AS datum INTO #T FROM Table1 The functi…
4 replies
Viewing 15 topics - 541 through 555 (of 3,249 total)
You must be logged in to create new topics.