Viewing 15 topics - 269,026 through 269,040 (of 283,901 total)
Topics
Started by
Posts
Last post
Does anyone have a script which will select the top x rows from every user table in a database? Th…
6 replies
create proc extractdata as begin tran if exists (select * from dbo.sysobjects where id = object_id(…
6 replies
I have a database aaa and i'm taking a full backup daily at 12 Am(I'm overwriting to the existing m…
2 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
3 replies
Hi All, what's the skinny on using table hints, (nolock), (rowlock) etc.. on Read-only databases? …
1 replies
Kinda dumb question --- sorry What are sql internals while altering tables - adding, updating, or d…
5 replies
How can I pass a table variable as a parameter to a stored procedure ? eg. create proc procname ( @…
2 replies
How can we use comments in access query like -- in SQL My Blog: http://dineshasanka.spaces.live.co…
5 replies
Can any one help me to know the sequence in which the constrains are fired ex.Check constraints, Fo…
2 replies
hi guys, how would i write the following sql statments using pl/sql table? SELECT to_char (orderdat…
1 replies
Hi All, Need urgent help. While monitoring an app. with perfmon, I noticed that the total latch w…
1 replies
I'm sure they aren't perfect by a longshot (I may even have functions that have other internal func…
14 replies
I have created a View with a clustered index. The View contains about 4.5 million rows. It works gr…
7 replies
Hi Guys, I would like to have know your solution on how to integrate stored procedures with VSS, so…
1 replies
I am replacing a production server. To minimize downtime, I am doing this over the holiday but I am…
4 replies
Viewing 15 topics - 269,026 through 269,040 (of 283,901 total)