Topics
Started by
Posts
Last post
Hello, I need tuning advices for large tables query performance. I have 3 big tables and I need to …
16 replies
I have a stored procedure(parent) which include to many if cases and in each case calls another sto…
7 replies
Hello All: I have an SSIS package with SharePoint List adapter as data source connection. I'm exper…
5 replies
I'm working on a data migration project, and one of the tables I was importing gave me this error: …
2 replies
We have a relatively straightforward database that the users access via a web page. The web page i…
4 replies
I am creating a table with data types. CREATE TABLE [dbo].[ED] ( [EDId] int IDENTITY(1,1) NOT N…
8 replies
Hi all, Does anyone have any scripts to find a list of all the failed jobs in the last 10 hours. I …
3 replies
I have a database that started giving me errors last night A system assertion check has failed. C…
5 replies
I came acroos a problem shared by a developer in my firm, He cretaes a SP & generates a report…
5 replies
here is my current, functional NTILE statement. select cr.sup, cr.part, cr.loc, cr.countrank, cr.da…
8 replies
I had a huge transaction (1.5 Billion) rows running for more than 24 hours and I see that after wor…
3 replies
Good Morning. Hoping someone can give me some insight as to the best approach for changing char fie…
8 replies
Hi All It's coming close to the end of the year and I have a table that requires a new partition fo…
2 replies
We have a certain query that now seems to result in tempdb growing until the disk runs out of space…
7 replies
Hi All, I need to know,How many transaction happening for a table in sql server 2008 R2 for a perio…
3 replies
Viewing 15 topics - 13,696 through 13,710 (of 30,212 total)
You must be logged in to create new topics.