Hello sql-server-perf, My team and i working on a project where there are a lot of dashboards(charts)(to see data...
Hi, Thank you Thulasi fot this info. as you have seen,although i have a clustered index in the table partition column,but...
Hi sql-server-performance, I have a dabase TesDatabase that have : *** 2 filesGroups:PRIMARY and FG1 and FG2....
Hi, Try to use the instead of trigger.Regards,Rachid
Hi sql-server-performance, 1-Why the sql server storage wizard makes a table partition column by defautl as "Clustered index"?...
Hello, i call from a client application a stored procedure that has a user defined table typethe sql profiler fails to trace it !! and...
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...
Hi, Did you test if your Dbmail sends already mails. Test outside the trigger . If it works,then something wrong within...
Hi sql-server-performance, I wonder if there is something in sql server that can enable me to automatically create...
Hi guys, i have a table : Create Table MyTabele ( Id INT indentity(1,1), FirstName...
Hi Frankkalis, Can you tell us where(tables) SQL Server saves all the code in system tables?ThanksRachid
Hi, Thank you Mohammed Following this thread i understand that what i'm trying to do is impossible as the databases already exist....
Hi everybody, i have created new login called 'rachid' in my SQL Server 2008 instance. after added it to 'Public'...
Hi Everybody, is here anyone who has generated a pivot table from a table containing a datatime column Explain:...
I have tested your suggestions. No one gives the result.it gives @ConcatStr=NULL Could u test...
Hi Everybody , I have a table DECLARE @ConcatStr varchar(Max)...
OKi.Thanks
Hello Everybody, i have a table BusineesGeoChildren(BusinessGeoId,BusinessGeoChildId). Primary...
After i disconnected from the instance and connected after,i dont see the pb anaymore. Thanks.
Separate names with a comma.