I am in the process of cross training a DBA. At this point, he has very little knowledge of ERwin 7…
1 day, 3 hours ago
I want the earliest 5 distinct dates for each user.
I know I can row_number() over partitio…
5 days ago
A SQL Server instance was restarted and one database did not come back online. The error message be…
3 weeks ago
SQL server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12…
1 month ago
By: Jeff Moden
Hello there. My company converted to SQL Server 2008 R2 as the backend for its inventory database …
1 month, 1 week ago
I am using SQL server 2008 R2 express edition.
Out of below 3 method which method is efficient to f…
1 month, 2 weeks ago
I have a table with phone number column, it contains land phone numbers & mobile numbe…
I am using SQL Server 2008 R2 Express edition. I have already set Maximum Server memory to 2Gb.…
By: Grant Fritchey
Hello, I am running the below restore script and getting errors. Please advise what I need to do t…
1 month, 3 weeks ago
By: Johan Bijnens
I am using sql server 2008 R2 Express edition.
Below is the Sql process information from Taskmanage…
2 months, 1 week ago
I'm looking for help in establishing an ODBC connection in Excel to an SQL Server database. I don't…
2 months, 2 weeks ago
By: Erland Sommarskog
I am using SQL Server 2008 R2.
While using XML data type and XQuery slow (50 Times slow) compare …
2 months, 3 weeks ago
A question I have not got a clear answer:
When installing SQL server 2008 or 2008 r2, we choose to …
3 months ago
By: Thomas Franz
I am using SQL Server 2008 R2 version.
Is there any method to store decimal value in SQL without ex…
3 months, 4 weeks ago
I'm trying to figure out which Job is running, based on this the following name. Where can I find t…
4 months, 1 week ago
By: Robert vd Berg
Viewing 15 topics - 1 through 15 (of 30,182 total)
You must be logged in to create new topics.