I have SQL Server 2005 on Windows Server 2003. Problem is queries are taking a lot of time. Example:
Select * from Table --[table has around 6000 records]
There are other databases too which are working fine but this is problem with one database.
I tried to DBCC DBREINDEX but it took 18 hours...
I have SQL Server 2005 on Windows Server 2003. It was fine 2 days before but now queries are taking a lot of time. Example:
Select * from Table --[table has around 6000 records]
There are other databases too which are working fine but this is problem with one database.
I tried to DBCC DBREIN...
This question was prompted by this earlier post and my having a database filed away for future investigation that was restored following:
BACKUP 'BrokenDatabase' detected an error on page (1:123456) in file ’BrokenDatabase.mdf'.
Error: 3043, Severity: 16, State: 1.
In the linked question and t...
My actual work query was an inner join, but this simple example with cross join seems to nearly always reproduce the problem.
SELECT *
FROM (
SELECT 1 UNION ALL
SELECT 2
) AA ( A )
CROSS JOIN (
SELECT NEWID() TEST_ID
) BB ( B )
With my inner join I had many rows for which I added t...
We have 10 Sql Servers (2005 2008) that programmers create their DBs there.
we want to documents them.
Is there any free tools that documents them
and has features like:
updated from changes or modifies on permissions or schema or new DBs that create everyday?
apply configs from this tools...
I have a stored procedure that truncates some tables with around 1.75M rows in each, before inserting new data (based on data in other tables, calculations etc.)
Basic outline is very simple:
Truncate Tables
Insert 1.75M rows in 'batches' of around 75,000 per time.
I am wondering if I should...
I have problem in selecting other columns for the max(datetime) records. In layman terms I need to get relevant columns where max(DialDateTime) records for all the dates in Mysql.
mysql> select max(DialDateTime) as max from log_AP group by date(DialDateTime) ;
+---------------------+
| m...
Please explain in more detail what you meany by "groupers"?
For instance, if you want to rank a member within a set, you need to tell SSAS what the set is that you are ranking within.
RANK( Tuple, Set, Measure to rank by)
So
RANK( Machines.Machines.CurrentMember, Machines.Machines.AllMember...
As it is December 2012, we are now going to reset our Community Promotion Ads for the new year. Funny timing, this is exactly 400 posts later.
What are Community Promotion Ads?
Community Promotion Ads are community-vetted advertisements that will show up on the main site, in the right sidebar. ...
In addition to Craig's advices I like advice you to examine the storage parameters of the affected tables.
I am currently in a similar situation as you. The largest table in my system contains ~200 million records and the performance was really bad.
Tune the storage parameters of your tables an...
Log back in as the administrator account (not an administrator), and start a command prompt with Run As Administrator. Then run this:
sqllocaldb share v11.0 MyInstance
You might want to explicitly add your Windows account as a sysadmin on this instance if that is a goal. So:
sqllocaldb start ...
It sounds like you're referencing the faq which states: (and has some links, so it's worth perusing if you're at all curious)
May I promote products or websites I am affiliated with here?
Be careful, because the community frowns on overt self-promotion and tends to vote it down and flag...
