Topics
Started by
Posts
Last post
Hi, We use log shipping in our 2008 R2 databases. On one of our large heavily used databases, tran…
6 replies
Please forgive my ignorance. I am more of a BI developer than a DBA. Is there a way to determine …
6 replies
Hi all, I have a requirement where in I need to select the date column of a table while it will b…
7 replies
Hi, I'm a beginner in index. I've table and data as following, CREATE TABLE [dbo].[Zip]( [City_C…
5 replies
All, I have couple of the databases are under suspect mode. What are some of the process you should…
6 replies
Today while i was at lunch, TEMPDB had massive autogrows until it filled the disk it sits on. When …
16 replies
Has anyone noticed a significant boost in performance from running their TempDB on SSDs?
5 replies
The C drive (OS, SQL assemblies) are stored in SAN Array1 and all data & log files are stored …
7 replies
Hello -- I configured our backup jobs to send notifications to the administrators on their respecti…
7 replies
How can I find data distribution for a column?
3 replies
Hi all, I ran into an interesting question from a developer on how to handle subscriptions on 2 …
8 replies
I have updated a column with null. The column data type is varchar(2000). i update 2 billion rows b…
1 replies
Hi All, Here is a scenario that I am going through and need your opinion on this. One of the app gu…
4 replies
I'm a new hire (developer....there are no DBAs) on a project whose database occupies 370GB on a dri…
12 replies
Hey Everyone :-), I wanted to try setting the max memory usage on my test environment as currently …
4 replies
Viewing 15 topics - 2,626 through 2,640 (of 6,200 total)
You must be logged in to create new topics.