Topics
Started by
Posts
Last post
When looking at the execution plan of a query it shows a 'Clustered Index Update' @ a cost of 85%. …
12 replies
when i execute my main sp , inner sp showing read count as 6000 ,but when execute that perticular …
5 replies
Hi Please tell me which is better for the performance impact ? 1. Insert into #temp table Using the…
7 replies
Dear all In my production server frequently(every four to six hour) i am getting time out problem …
1 replies
Hi all I have and issue with a query in SQL Server 2012 SELECT top 1000 firmas.TipoPers, firmas.Cod…
8 replies
Can anyone send me some interview questions pls. I recently got into DBA and I wanna stick to it as…
40 replies
Hi there, I have a raw table that I get every friday night after stocks close, which gives 45 da…
1 replies
Hi Guys! Can anyone tell me if there is any functional or performance difference between designing …
11 replies
I have a series of SPs that run nightly. They run twice each, once building current month data, onc…
3 replies
Hi all I've got a real head-thrasher on my hands. I've got a stored procedure that takes a paramete…
6 replies
1)Assuming Process, Organization and Department tables all exist. please show me how you would cr…
4 replies
We are running SQL Auditing which captures hostname, login ids,applicationname, servername etc. Tod…
2 replies
Hi Please help, I am new on SQL, I need all the t-sql queries that can get me started with data pro…
4 replies
By: CeliweM
I have a fairly large table with roughly 120 million rows. It has a primary key composed of 3 integ…
18 replies
Good morning, Yesterday night, I rebuilded all indexes one a table since they were having high perc…
33 replies
Viewing 15 topics - 16 through 30 (of 3,249 total)
You must be logged in to create new topics.