Most Popular
1500 questions
20
votes
3 answers
What does "collation" mean?
I am learning sqlite from a book which has mentioned collation and collating sequence multiple times. What does it mean exactly in the database world?
mumtaz
- 777
- 1
- 7
- 10
20
votes
6 answers
What is SQL Server "Denali"? What's new?
I found a new title called SQL Server "Denali" in the drop down list on MSDN, but I didn't find much information about it:
What's New (this documentation is for preview only as I see)
Top 9 New Features of SQL Server "Denali"
Does anyone have more…
garik
- 6,782
- 10
- 44
- 56
20
votes
3 answers
How does shrinking a SQL Server log file affect performance?
I have a SQL Server 2008 database that has a data file of some 2GB in size, but the log file is over 8GB. With pre-2008 databases I could use the 'Backup log' and the TRUNCATE_ONLY option but this is no longer available with 2008 and later…
MartinHT
- 311
- 1
- 2
- 6
20
votes
5 answers
Optimal drive configuration for SQL Server 2008R2
I have a fairly busy database server running SQL Server 2008 R2 that has the following setup:
SATA RAID 1 (2 Drives) - OS / Programs
SAS RAID 10 (4 Drives) - Sql Database Files (data and logs)
SAS RAID 1 (2 Drives) - TempDB (data and…
DanP
- 255
- 1
- 2
- 9
20
votes
4 answers
Is it better to separate a big query into multiple smaller queries?
There are situations which require having really big query joining several tables together with sub select statements in them to produce the desired results.
My question is, should we consider using multiple smaller queries and bring the logical…
2hamed
- 323
- 1
- 3
- 7
20
votes
3 answers
Is there a standard implementation of a Users Database?
I need to implement basic personalized user functionality for my website. Is there a standard structure for databases of this type? Like is it common practice to have all user info and data in a single table with each user having his own row, or…
cfrederich
- 435
- 2
- 4
- 8
20
votes
5 answers
Primary filegroup is full SQL Server 2008
I have a large table (~50 million rows) I'm trying to bulk insert into SQL Server and I get the error:
Could not allocate space for object 'myDB' in database 'I 3 Stroke' because the 'PRIMARY' filegroup is full. Create disk space by deleting…
wootscootinboogie
- 459
- 2
- 6
- 14
20
votes
1 answer
Warning in query plan "Cardinality Estimate"
create table T(ID int identity primary key)
insert into T default values
insert into T default values
go
select cast(ID as varchar(10)) as ID
from T
where ID = 1
The query above has a warning in the query plan.
Mikael Eriksson
- 22,295
- 5
- 63
- 106
20
votes
5 answers
Best cloud platform for PostgreSQL
Currently, in our project, we use dedicated servers for our PostgreSQL database.
In theory, we can run anything on some cloud platforms. However, PostgreSQL configuration is strictly related to hardware configuration. What we are looking for is a…
Vlad Minaev
- 301
- 1
- 2
- 4
20
votes
4 answers
How can I backup a large SQL Server database without impacting performance?
We've had reports of queries running slowly or timing out early in the morning, and the only job I see running that I think could affect this is our database backup job.
The database itself is about 300GB, and the backup job starts at 4:30am and…
Rachel
- 8,547
- 20
- 51
- 74
20
votes
2 answers
Deadlocks From Locks on Same Temporary Tables In Different Processes
I have found a deadlock that appears to show something I thought was impossible. There are two processes involved in the deadlock:
1. process8cf948 SPID 63
Performing an ALTER TABLE on temporary table #PB_Cost_Excp_Process_Invoices_Work.
Owns IX…
Paul Williams
- 1,434
- 2
- 14
- 23
20
votes
2 answers
SQL Server in-memory optmized tempdb metadata memory usage continually growing
Problem
We have enabled sp_configure 'tempdb metadata memory-optimized' = 1, and now the tempdb meta data is taking over 400 GB on one of our servers and continues to grow. There are some drops in memory usage, but generally it keeps growing it's…
SQLing4ever
- 488
- 4
- 8
20
votes
3 answers
How to treat numbers within strings as numbers when sorting ("A3" sorts before "A10", not after)
For all of these queries:
SELECT label FROM personal.storage_disks ORDER BY label ASC;
SELECT label FROM personal.storage_disks ORDER BY label COLLATE "C" ASC;
SELECT label FROM personal.storage_disks ORDER BY label COLLATE "POSIX" ASC;
SELECT label…
user15080516
- 745
- 3
- 8
- 12
20
votes
5 answers
Download SQL Server Profiler for SQL Server Management Studio
How can I profile a SQL Server 2008 database to see code that's being executed on a particular database? I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio after downloading SQL Server 2008 R2 Express. …
JustBeingHelpful
- 2,116
- 18
- 45
- 61
20
votes
3 answers
Set "lock wait timeout" in MySQL
Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?
Gaius
- 11,238
- 3
- 32
- 64