Search Results | SQL Server Performance Forums

Slow Stored Procs:normal?

Thread by: AMOURGH, Jul 28, 2009, 1 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hello sql-server-perf, My team and i working on a project where there are a lot of dashboards(charts)(to see data...

Restore a database from a backup with more files than the target database

Thread by: AMOURGH, Jul 21, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hi sql-server-performance, I have a dabase TesDatabase that have : *** 2 filesGroups:PRIMARY and FG1 and FG2....

Question about table partitioning

Thread by: AMOURGH, Jul 20, 2009, 5 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hi sql-server-performance, 1-Why the sql server storage wizard makes a table partition column by defautl as "Clustered index"?...

Trace skipped records

Thread by: AMOURGH, Jul 15, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hello, i call from a client application a stored procedure that has a user defined table typethe sql profiler fails to trace it !! and...

Help-Data Integration from different Data Sources to SQL Server 2008 Database

Thread by: AMOURGH, Jul 15, 2009, 1 replies, in forum: SQL Server 2008 General Developer Questions

Hi sql-server-performance, i'm working in a project where data are collected and i'm responsible for integrating them(Data import to SQL Server)into...

Help-Data Integration from different Data Sources to SQL Server 2008 Database

Thread by: AMOURGH, Jul 15, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hi sql-server-performance, i'm working in a project where data are collected and i'm responsible for integrating them(Data import to SQL Server)into...

Synchronize DataBases Structures

Thread by: AMOURGH, Jul 13, 2009, 1 replies, in forum: SQL Server 2008 General DBA Questions

Hi sql-server-performance, I wonder if there is something in sql server that can enable me to automatically create...

Extract Data form an nvarchar colum that contains strings with diffrent collation

Thread by: AMOURGH, Jul 11, 2009, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi guys, i have a table : Create Table MyTabele ( Id INT indentity(1,1), FirstName...

Pb with user access to a dababase-Permissions

Thread by: AMOURGH, Jul 2, 2009, 2 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

Hi everybody, i have created new login called 'rachid' in my SQL Server 2008 instance. after added it to 'Public'...

Pivot Table with Dates Columns

Thread by: AMOURGH, Jun 12, 2009, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi Everybody, is here anyone who has generated a pivot table from a table containing a datatime column Explain:...

Concatenate Column data without using a cursor

Thread by: AMOURGH, Mar 18, 2009, 7 replies, in forum: SQL Server 2008 General DBA Questions

Hi Everybody , I have a table DECLARE @ConcatStr varchar(Max)...

Point of view about index creation

Thread by: AMOURGH, Mar 2, 2009, 2 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hello Everybody, i have a table BusineesGeoChildren(BusinessGeoId,BusinessGeoChildId). Primary...

SQL Server shows some tables as unknown when i refernece them

Thread by: AMOURGH, Feb 28, 2009, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hello everybody, To make a change in a stored proc , i opened its script and at that time i created a new table in my DB and...

Using an Table-value-function a part of select query

Thread by: AMOURGH, Feb 26, 2009, 16 replies, in forum: SQL Server 2008 General DBA Questions

Hello everybody, I try to call a udf returnin a table as a part of a query but it seems SQL Server doent accept ....

Maximum time allowed for a stored Proc

Thread by: AMOURGH, Feb 25, 2009, 5 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hello Everybody, I have a question:what's the maximum time allowed by users for a stored Proc. I have...

Very Slow Stored Proc

Thread by: AMOURGH, Feb 16, 2009, 9 replies, in forum: SQL Server 2008 Performance Tuning for DBAs

Hi Everybody I have a stored proc that uses a cursor . Each time ,the cursor forward(fetch next into),i do some...