Viewing 15 posts - 6,346 through 6,360 (of 22,211 total)
The SQL Server documentation itself is pretty extensive. But, there's also a guide available here on SQL Server Central.[/url]
April 13, 2015 at 5:24 am
An online restore is an Enterprise only type of restore where you're restoring secondary files or filegroups while the primary file group is online and accessible. There's extensive documentation on...
April 13, 2015 at 5:20 am
There's also a knowledge base article on possible issues here.
April 13, 2015 at 5:18 am
It's usually kind of rare to see major network issues. Are doing the bulk load from an external source? I'd work with the network people to see if there's some...
April 13, 2015 at 5:14 am
You just have to make the calls to the in-memory objects. It's actually not very different at all from calling the regular tables. The one exception is when you have...
April 13, 2015 at 5:10 am
GilaMonster (4/13/2015)
Luis Cazares (4/10/2015)
http://www.sqlservercentral.com/Forums/FindPost1676220.aspx
But, think about it, what if you're in situation...
April 13, 2015 at 5:04 am
RTM means Release to Manufacturing. It's the released product without any kind of updates or service packs applied. It's not recommended to use RTM.
To use the cumulative update, you only...
April 13, 2015 at 5:02 am
Better would be to have a timeout on the application side. If you kill the connections, you could see data loss.
But, you can look at sys.dm_exec_connections to see the connection...
April 12, 2015 at 8:12 am
Exactly the kind of information it's always best to go directly to the source for. This is Microsoft's documentation on the OS versions required for SQL Server 2014. The two...
April 12, 2015 at 8:08 am
I post the query into the message box. Then, over on the left side of the screen you'll see all the IFCode Shortcuts. Highlight your query and click on the...
April 12, 2015 at 4:15 am
Excellent points Eirikur. I agree. I do like the checklist for the common problems, using the wrong data type, functions on columns, stuff like that. But even those, tell people...
April 11, 2015 at 2:42 pm
So, the other problem is, you're going after sys.dm_exec_query_stats. That records the statements. That's what it's for. If you only want to see "objects," and by that definition we mean...
April 11, 2015 at 7:21 am
Excellent! Couldn't agree more.
April 11, 2015 at 4:51 am
The clue is the start and end offset. They are statements in a single batch. The queries in a batch are stored seperately, but the batch, especially in the sql...
April 11, 2015 at 4:48 am
As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do it is COUNT. Everything I...
April 11, 2015 at 4:43 am
Viewing 15 posts - 6,346 through 6,360 (of 22,211 total)