Topics
Started by
Posts
Last post
I have a SQL Server 2005 box with about 300 databases on it. The server doesn't have enough space f…
2 replies
I have an update statement that returns a different value each time it runs. I'm not sure why. Th…
6 replies
Hello Can anybody give suggestion for shrink .ldf file my ldf file size is 37 GB how can I shrink 5…
5 replies
From the below table, I need to calculate the number of hours took from creation to finalize and sh…
1 replies
Hi All I’m trying to write a query that would loop through ten variables and print the values of th…
2 replies
Hi, I have a join consisting of two tables (VCTMovements and VCTHaulageMileageLog). SELECT * FROM V…
2 replies
Does anyone else has an experience of using Over(Partition By) and getting an incomplete data set. …
2 replies
I have a table that looks something like this: EventID Ev_Cat Ev_Date Ev_status 1 …
3 replies
Hi I am new to SQL and I am just wondering if there is a solution to a problem I am having. I am us…
1 replies
Hello, I hope someone can help me out. I am trying to select the maximum log size in a table column…
2 replies
I have created a stored procedure that takes 2 parameters which are 2 database names. Within the pr…
5 replies
Hello I have a restore job that runs one of our servers and I have to script out all the permission…
5 replies
Hi to all, Need help on this one, Basically the problem is this. If the ItemSubID is NULL then the …
2 replies
Hi All, In an unavoidable situation, I'm using ##Table in my stored procedure. How will it behave i…
21 replies
I have many databases on one server that have the same table. I need to delete the contents of the …
4 replies
Viewing 15 topics - 2,311 through 2,325 (of 12,230 total)
You must be logged in to create new topics.