Topics
Started by
Posts
Last post
SQL Server 2008 R2 instances are installed on machine A and B respectively. Also, A is the middle s…
5 replies
By: Gazareth
How could i take a store-procedure backup in sql sever 2008 without taking a script backup. Actual…
3 replies
I am working on migrating data from access to sql server by using sql server migration assistant fo…
1 replies
By: vinu512
SELECT TOP 10000 newid, * FROM [original-data] WHERE State="PE" ORDER BY Zip; The column "newid" d…
3 replies
Hello, does anyone know a way to connect OLAP cube data from Cognos TM1 using OLE DB Provider or wh…
1 replies
By: j.webber
is it advisable to stop the update statistics job while its still running on prod env...its taking …
4 replies
By: Pyman
for example here i am using five table? table1 catid categoryname 1 cricket 2 foo…
1 replies
what is the best way to reorganize and rebuild all indexes of database?
2 replies
Please refer to the query below: DECLARE @applicationID int = 203, @logType varchar(50) = 'all', …
2 replies
I have been asked in an interview.. why should we go for trigger when we can achieve the same by th…
6 replies
By: GSquared
Hi everyone, I have a table that holds all the user log in data... basically, when a user logs in…
11 replies
I am going to do data purging in my databases. I guess it will have around 20% of data will be remo…
3 replies
Dear All, I would like to find more about the Disadvantages of Transactional Replication as it is t…
6 replies
Need help in exporting single table having 25 million records to multiple flat files of less than …
2 replies
I have a table with a tree structure (IdIndividual, IdMother, IdFather). Is there a way to find if …
5 replies
By: GSquared
Viewing 15 topics - 17,641 through 17,655 (of 30,188 total)
You must be logged in to create new topics.